Conditional Formatting

S

Sam A

Is it possibe somehow to have more than three conditional
formats for a cell. I need to colour cells one of five
colours depending on the data in the cell. Thanks
Sam
 
B

Bob Umlas, Excel MVP

conditional formats are limited to 3. To do more than that you'd need to use
VBA code to test the result of the cell & color it depending on the
conditions met -- this would likely have to be done in a Worksheet_Calculate
Event.
HTH
 
Top