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

  • Thread starter Thread starter All Star
  • Start date Start 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
 
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
 
Back
Top