I need some assistance please! I have an Excel spreadsheet to which I need to apply conditional formatting, based on 2 fields (let's call them Date and Status). Based on the values of the fields, I need to change the background of the entire row (if possible) to a specific color.
Date within 5 days of current date + Status not equal Complete = yellow background
Date is same as current date or later + Status not equal Complete = red background
Any row with Complete status = green background
Your assistance is greatly appreciated!