• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting with to match against rows and columns of data

S

sampahmel

New Member
Hi all,

I am looking to use conditional formatting to highlight cells in which the date exceeds a given date.

However, I'm looking to implement this over multiple dates. How do I proceed?

Attached is a example worksheet to illustrate the situation.

Thank you.
 

Attachments

Hi Narayank991,

I tried to replicate what you did in another case but failed. Can you tell me what went wrong?

Please refer to the file as attached below.

 

Attachments

Hi,

I tried to do the same thing in another file using =AND(C$5<>"", $C5<D$3) but it still doesn't produce what you gave me, which is what I want.

Is there any steps that I'm missing?

FYI, I went to Conditional Formatting, choose "Use a Formula to Determine which cells to format", applied the formula you have given me over D5:G27, and still in another of my new file that it doesn't do what I want.

Given that the date in column and date in row matches (american style), that shouldn't be a problem right?

NARAYANK991 said:
Hi ,

What is your system date format ? Is it mm/dd/yyyy or is it dd/mm/yyyy ?

See your file now.

Narayan
Click to expand...
 
Hi ,

In the file you have uploaded earlier , the data in row 3 is real dates , which Excel can use correctly for comparison purposes ; when I apply the same format , using the Format Painter , to the data in column C , the format of the data does not change , which means the data in column C is text.

When I select each cell in turn , press F2 and ENTER , your formatting gets applied correctly.

Narayan
 
You must log in or register to reply here.
Back
Top