I have a merged cell (C5-N5) that I want to change the fill color, based on the combined input of two cell values. I'll just call it "C5" from now on.
C5 already contains a number formula that counts between two dates, entered in E3 and I3: =DATEDIF(E3,I3,"D")
Here is an example of the color option I want C5 to have, based on the calculated number it already has:
--If C5 is between 0-30, AND if N3="N" (It's a cell where users enter either "Y" for "Yes," or "N" for "No"), then fill the cell with the color that is labeled on Excel as "Dark Blue, Text 2, Lighter 80%."
I hope that makes sense. Thank you, in advance, for your help.
Related:
Excel conditional formatting formula between two values
