Hi,

In my spreadsheet, H6:H13 have dates; L7, L9 and L11 have 0 (zero) as a
result of formulas; I highlighted M6:M13; selected Formula Is for
Conditional Formatting and entered =AND(H6:h13<"",L6:L13=0); and
selected the Diagonal Stripes pattern. Nothing happened when I clicked
OK. Can anyone tell me why?

Thank you,
Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=512414