Conditional Formatting

[Gos-C]

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

 

[Guest]

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.