conditional formatting an area

[___Zoom]

Hi to all Excel friends,
I have a sheet which contains in an rectangular area (say starting from B11 top left corner to AA44 at the bottom right) with various day numbers from all different months in. I need to check every one of thouse cells if it has todays day number (and today's month) and color code only thouse cells which has passed dates in it.
A conditional formatting or a macro solution is acceptable. Can anybody suggest a solution?
Thanks
___Zoom

 

[Ruddles]

Conditional formatting is exactly the right tool to use:-

• Highlight the range you want to format
• Conditional formatting
• New rule
• Use a formula to determine which cells to format
• =AND(B11>0,B11
• Set your foreground/background colours as required

<TODAY())< b>

 

[___Zoom]

I was more looking forward to read info and commands related to "date check" as conditional formatting criteria.
But thank you anyway
___Zoom

 

[Ruddles]

I was more looking forward to read info and commands related to "date check" as conditional formatting criteria.
But thank you anyway
___Zoom

Oops, sorry, my formula got chopped. It should have read:-

[B]=AND(B11>0,B11< TODAY())[/B]

(Tested and working here.)

 

[___Zoom]

Thank you Ruddles,
Why did you use the "B11>0" term?. Just to make sure it aint an empty cell?
___Zoom

 

[Ruddles]

Because an empty cell would be less than today, so it would get flagged. I assumed you didn't want that.

 

[___Zoom]

Yes, you assumption was correct. And the formula worked very well indeed.
Thanks a lot.
___Zoom