Previous Topic Next Topic

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
 -
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.
Related:

2 replies

Answer 1 / 2
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
 147
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