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

[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

 

[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

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