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.