Menu

Conditional Formatting: Highlight cells based on two values [Solved/Closed]

Report
Posts
6
Registration date
Saturday March 29, 2014
Status
Member
Last seen
July 12, 2014
 -
Plastic_Cup_of_Stars
Posts
6
Registration date
Saturday March 29, 2014
Status
Member
Last seen
July 12, 2014
 -
Hello,

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.
See more

2 replies

Answer 1 / 2
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 134
Good morning.

Try to use it.

--> Conditional formating
--> use formula =AND(C5>=0,C5<=30,N3="N")
--> choose your layout

Is it what you want?
I hope it helps.
Answer 2 / 2
Posts
6
Registration date
Saturday March 29, 2014
Status
Member
Last seen
July 12, 2014
I want to thank you so VERY much for your help! This is exactly what I needed. Perfect!! :-)
Ask a question