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
the web designer group uk
the webdesigner group logo

Close Button

Web Site Designed by

The Web Designer Group