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
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.
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:
- How to highlight a cell if another cell contains text
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Formatting windows 7 - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 30, 2014 at 02:19 PM
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.
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
Posts
6
Registration date
Saturday March 29, 2014
Status
Member
Last seen
July 12, 2014
Apr 2, 2014 at 10:22 PM
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!! :-)
