In my xl03, I'd do the CF this way

Assume that I want the CF to colour both cols H & I red
if the criteria stated is fulfilled

Select H8:I20 (with H8 active)
Click Formatting Conditional Formatting
Formula Is: =AND(ISNUMBER($H8),$H8<TODAY(),$I8="")
Click Format button Patterns tab Red OK
Click OK

The additional ISNUMBER check on col H is to ensure that blank cells in col
H (if any) will not spuriously trigger the CF. Blank cells are evaluated as
zeros in formulas, which is equivalent to a date of 0-Jan-1900.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"Yolanda" wrote:
Thank you Sheeloo, but I am not familiar with EXCEL at all. Could you tell
me exactly how I would enter the formula? Is it: =IF H8<today()ANDi8=''''
(cell background turns RED?????