Good day all,
Having some problems stringing a formula together for conditional formatting.
Dual formula
On the attached example.
Format Cell C4 - IF Forecast Date is greater then target date by 1 - 3 days format Amber
Format Cell C4 - IF Forecast Date is greater then target date by 3 days or more format Red
Format Cell C4 - IF Forecast Date is less than or equal to then target date format Green
Additional Format - Highlight Cells in Column E - Rows 3-4 based on the format in Cell B4
Thanks
Tim
Bookmarks