Previous Topic Next Topic

Conditional Formatting: Highlight cells based on two values

Solved/Closed
Plastic_Cup_of_Stars Posts 6 Registration date Saturday March 29, 2014 Status Member Last seen July 12, 2014 - Mar 29, 2014 at 12:20 AM
Plastic_Cup_of_Stars Posts 6 Registration date Saturday March 29, 2014 Status Member Last seen July 12, 2014 - 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.

2 responses

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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses