Related:
- Conditional formatting for a range of cells
- Excel conditional formatting range - Best answers
- Excel conditional formatting range of cells - Best answers
- Copy conditional formatting for an entire row based on one cell ✓ - Forum - Excel
- Conditional formatting range of cells ✓ - Forum - Excel
- Conditional formating - apply on more cells ✓ - Forum - Excel
- Conditional formatting greater than another cell ✓ - Forum - Excel
- Highlight a cell greater than the one above ✓ - Forum - Office Software
2 replies
Blocked Profile
Just compare the value in the two cells, and format it based on the condition. What if the cell contain "hello"? Would you be able to turn the cell red? Use the same type of formula to compare the values! Post back if you still have hardships!
TrowaD
- Posts
- 2717
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- April 1, 2021
Hi Rob,
May this pic guide you to your solution:
Best regards,
Trowa
May this pic guide you to your solution:
Best regards,
Trowa
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
many thanks
"IF(DATEVALUE,$D$2:$O$2<DATEVALUE,B2)" and formatting this for green.
and the same formula with > to be red.
but it is not working.