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

Plastic_Cup_of_Stars 6 Posts Saturday March 29, 2014Registration date July 12, 2014 Last seen - Mar 29, 2014 at 12:20 AM - Latest reply: Plastic_Cup_of_Stars 6 Posts Saturday March 29, 2014Registration date July 12, 2014 Last seen
- Apr 2, 2014 at 10:22 PM
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

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 30, 2014 at 02:19 PM
0
Thank you
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.
Plastic_Cup_of_Stars 6 Posts Saturday March 29, 2014Registration date July 12, 2014 Last seen - Apr 2, 2014 at 10:22 PM
0
Thank you
I want to thank you so VERY much for your help! This is exactly what I needed. Perfect!! :-)