MrExcel Publishing
Your One Stop for Excel Tips & Solutions

reverse conditional formatting

Posted by bob found on February 13, 2002 7:30 PM

How do I write text to a cell based on the COLOR of an empty cell (empty of data)? I have 1500 rows with cells containing 5 different colors; before I export to another program (for process control), the colors have to be replaced with captions like "warning", "danger", "status", etc. How can I do this? It's exactlly the opposite of conditional formatting where a cell can be colored based on the text it contains.

Posted by DRJ on February 13, 2002 8:10 PM


To do this with vb you could do

select case activecell.interior.colorindex

case 3 'Red

case 10 'Green

case 5 'Blue

end select

then do what you want based on the value.

You can also make a custom function to do this.