Forum Discussion
Solved
Conditional Formating For Individual Cells
Hi, I have two rows - Due date and date received respectively. Is there a way to quickly conditionally format the cells so that if row 2 (date received) is greater than row 1 (due date) color it ...
=B4<B3You can try this rule for conditional formatting for Date received < Date due.
=B4>B3You can try this rule for conditional formatting for Date received > Date due.
=$B$4:$E$4This is the range the formatting applies to.
=B4<B3You can try this rule for conditional formatting for Date received < Date due.
=B4>B3You can try this rule for conditional formatting for Date received > Date due.
=$B$4:$E$4This is the range the formatting applies to.
- Thank you so much for the quick response! This is exactly what I was looking for 🙂
