software

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:h13lt;gt;quot;quot;,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: www.excelforum.com/member.php...oamp;userid=14518
View this thread: www.excelforum.com/showthread...hreadid=512414This one seems to work:

=AND(H6lt;gt;quot;quot;, L6 = 0, L6lt;gt;quot;quot;)

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 Vaughnquot;Gos-Cquot; wrote:

gt;
gt; Hi,
gt;
gt; In my spreadsheet, H6:H13 have dates; L7, L9 and L11 have 0 (zero) as a
gt; result of formulas; I highlighted M6:M13; selected Formula Is for
gt; Conditional Formatting and entered =AND(H6:h13lt;gt;quot;quot;,L6:L13=0); and
gt; selected the Diagonal Stripes pattern. Nothing happened when I clicked
gt; OK. Can anyone tell me why?
gt;
gt; Thank you,
gt; Gos-C
gt;
gt;
gt; --
gt; Gos-C
gt;
gt;
gt; ------------------------------------------------------------------------
gt; Gos-C's Profile: www.excelforum.com/member.php...oamp;userid=14518
gt; View this thread: www.excelforum.com/showthread...hreadid=512414
gt;
gt;