Conditional Format: What is formula to compare to a Date?

A

All Star

If All rows in Column B > than 11/1/03 highlight.

I know to turn CondFormt to formula: =$B1= ???Date comparison???


thanks much,
All Star
 
R

Ron Rosenfeld

If All rows in Column B > than 11/1/03 highlight.

I know to turn CondFormt to formula: =$B1= ???Date comparison???


thanks much,
All Star
Click to expand...

Here's one way:

Highlight B1:Bn
Format/Conditional Formatting
Formula Is: =COUNTIF($B$1:$B$n,">"&DATE(2003,11,1))=40

or you can substitute a cell reference for the DATE function.


--ron
 
Top