Forum Discussion
frizz72
Jul 16, 2021Copper Contributor
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...
mtarler
Jul 16, 2021Silver Contributor
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
format red: =MIN($F13:$M13)<TODAY()
format orange: =MIN($F13:$M13)<=TODAY()+30