Forum Discussion
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 red and if it's less than then color it green? This is part of a bigger data set so I would be grateful if someone as a solution to this! Thanks in advance!
=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.
2 Replies
=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 🙂
