IF statements and conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1176624%22%20slang%3D%22en-US%22%3EIF%20statements%20and%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176624%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20conditional%20formatting%20set%20to%20change%20the%20colour%20of%20the%20cell%20when%20it%20becomes%20overdue%20based%20on%20todays%20date.%20it%20is%20green%20whilst%20in%20date%2C%20and%20then%20red%20once%20over%20due.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20it%20to%20change%20to%20another%20colour%20once%20data%20is%20entered%20in%20the%20cell%20next%20to%20it%2C%20which%20is%20blank%20until%20this%20data%20is%20entered.%26nbsp%3BThe%20concept%20is%20to%20track%20when%20documents%20are%20over%20due%2C%20but%20then%20once%20they%20are%20received%20and%20date%20captured%2C%20that%20the%20over%20due%20colour%20changes%20to%20show%20no%20longer%20over%20due.%20Thanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1176624%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1176719%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statements%20and%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F559969%22%20target%3D%22_blank%22%3E%40clare1981%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tweaked%20the%20formulas%20in%20column%20F%2C%20H%20and%20J%20and%20used%20formulas%20to%20make%20new%20rules%20for%20conditional%20formatting%20for%20these%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20attached%20for%20more%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have conditional formatting set to change the colour of the cell when it becomes overdue based on todays date. it is green whilst in date, and then red once over due.

 

I want it to change to another colour once data is entered in the cell next to it, which is blank until this data is entered. The concept is to track when documents are over due, but then once they are received and date captured, that the over due colour changes to show no longer over due. Thanks in advance

 

1 Reply

@clare1981 

I have tweaked the formulas in column F, H and J and used formulas to make new rules for conditional formatting for these columns.

 

Please refer to the attached for more details.