Identify if cell is coloured by conditional formatting in VBA

Identifying whether a cell is coloured by Conditional formatting.

This code will only work with Excel 2010 onwards and by choosing a cell then running the short code below, a message box will output the Conditional Format Cell Fill Colour. It can be adapted to show font colour etc.

Please note that Excel uses the US spelling, Color


msgbox ActiveCell.DisplayFormat.Interior.ColorIndex






Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us

Datanology