Forum Discussion
NickMulligan
Oct 27, 2021Copper Contributor
Vlookup to return cell colour reference
Hi See attached spreadsheet with two tabs. The Training Matrix tab contains the dates my staff passed the relevant training courses. These are then coloured red, green or orange to represent the ...
SergeiBaklan
Oct 27, 2021Diamond Contributor
Formulas don't work with cell properties like colour, only with values. Perhaps you have another values-based logic?
NickMulligan
Oct 27, 2021Copper Contributor