-
Code to show if cell interior colour is red
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
-
You need to test if the conditions are met which make the cell red. The Interior Colour cannot be used for this purpose.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules