Returning a value based on a cell colour

Hi Anna.

Thank you for the forum question.

The answer is yes and no.

If you can write VBA codes you can test the fill colour and return a value based on the colour code. If you do not have VBA knowledge unfortunately it is not possible.




ind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector