Conditional Formatting: Highlight cells based on two values
Solved/Closed
Plastic_Cup_of_Stars
Plastic_Cup_of_Stars
- 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
Related:
- How to highlight a cell if another cell contains text
- Excel conditional formatting if another cell is between two values - Best answers
- Highlight cell if another cell contains text - Best answers
- Conditional formatting highlight cell if another cell contains text ✓ - Forum - Excel
- Conditional format to highlight cell based on date ✓ - Forum - Excel
- Conditional formatting: change fontcolor based on another cell ✓ - Forum - Excel
- Conditional formating is applied based on date in two cells ✓ - Forum - Excel
- Conditional formatting highlight row if cell contains date ✓ - Forum - Excel
2 replies
Mazzaropi
Mar 30, 2014 at 02:19 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
Apr 2, 2014 at 10:22 PM
- 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!! :-)