Conditional Formatting
 

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

Conditional Formatting
 

This one seems to work:

=AND(H6<"", L6 = 0, L6<"")

However, your question is actually why. I can't answer that. It would
appear your formula would need to be an array formula, but I tried entering
with cntl-shift-enter and it still didn't work. I don't know if as a general
rule conditional formatting can be an array formula.
--
Kevin Vaughn


"Gos-C" wrote:


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