Forum Discussion
Conditional Formatting - HELP
I have attached the file for reference. I am creating a tracking tool that is specific to our business needs. However I am hitting a wall using conditional formatting to initiate a status update (Based on color shading) between three specific dates. Dates needed are; Actual Date (if task completed), Today's Date, and Due Date (To determine items approaching due or OVERDUE). Please see file attached. First columns in questions are (H, I, J). Today's Date is auto populated to update in (C,2)
Thank you!
1 Reply
Rachele-
I have added two conditional formatting formulas to your worksheet that highlight overdue red and within 5 days yellow.
The formulas are based on the values in Column I and are applied to this range:
=$B$6:$BJ$32
Remember that conditional formatting rules are applied in the order shown in the Conditional Formatting Rules Manger
Overdue:
=$I6<$C$2
Within 5 Days:
=AND($I6<($C$2+5),$I6>$C$2)
Here are a few additional resources:
https://exceljet.net/blog/test-conditional-formatting-with-dummy-formulas
Hope this helps solve your issue!
