Conditional Formatting using dates/data in an adjacent cell
Closed
CDP1524
-
Oct 29, 2018 at 12:48 PM
TrowaD
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Conditional Formatting using dates/data in an adjacent cell
- Conditional formatting with dates: in Excel - Guide
- Conditional Formatting Based on Data in another Cell ✓ - Forum - Excel
- Conditional Formatting using dates ✓ - Forum - Office Software
- Conditional formatting using dates in different cells ✓ - Forum - Excel
- Conditional formatting change font color based on another cell ✓ - Forum - Excel
1 reply
TrowaD
Oct 30, 2018 at 12:24 PM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Oct 30, 2018 at 12:24 PM
Hi CDP1524,
Try using this formula:
=$C2>$B2
Use the "applied to" box to choose the cells you want to format.
For example: =$C$2:$C$100
Best regards,
Trowa
Try using this formula:
=$C2>$B2
Use the "applied to" box to choose the cells you want to format.
For example: =$C$2:$C$100
Best regards,
Trowa