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
Hi
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.
HTH
DRJ
