Forum Discussion

frizz72's avatar
frizz72
Copper Contributor
Jul 16, 2021
Solved

Excel Colouring cell nightmare

Hi, I am getting to the stage when i will have no hair left to pull out.   I have put a spreadsheet toghter (See Below) to show employees training records, i have used "Conditional Formatting" to s...
excel
Formulas and Functions
  • frizz72's avatar
    frizz72
    Jul 16, 2021

    mtarler 

    Your a star, works like a dream.

mtarler's avatar
mtarler
Silver Contributor
Jul 16, 2021
In conditional formatting you will need to add 2 new items with custom formulas both applied to the names (I think that would be A13:B50 or maybe also include col C?):
format red: =MIN($F13:$M13)<TODAY()
format orange: =MIN($F13:$M13)<=TODAY()+30
  • frizz72's avatar
    frizz72
    Copper Contributor
    Jul 16, 2021

    mtarler 

    Your a star, works like a dream.

Resources