PDA

View Full Version : Code to show if cell interior colour is red



BENSON
09-17-2009, 10:44 PM
I need some code that will identify if a cell interior colour is red when a conditionl format is met. ie if in a range "G5:G30" cells "G6" and "G22" are high lighted red because the conditionl format has been met, a mesg box appears to indicate the cells that are red.

thanks

mdmackillop
09-18-2009, 02:33 AM
You need to test if the conditions are met which make the cell red. The Interior Colour cannot be used for this purpose.