Hi there. I am having a problem with a nested, conditional IF formula.

Heres my current formula:
=IF((AND($J$3=$D6,$J$3<=$E6)),"",$C6)

The inner part of the formula €“ ($J$3€¦...$E6) is a condition that fills a
cell Red/False or Blue/True. If the condition is False then another
numerical value from C6 should be entered, and if its True then nothing is
entered.

After I added the IF statement with , €œ€�,$C6), the numerical value in C6
actually was entered in the correct place, but the red and blue formatting
from the inner part of the formula is gone, and I end up with a gray/lavender
fill. Any ideas to retrieve correct formatting?

--
Gayle