Conditional Formatting

[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

 

[Guest]

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