Conditional Formatting

  • Thread starter Thread starter Sam A
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about conditional formatting of zeros in Excel 0
Conditional Formatting - Excel 2003 2
Excel Conditional Formatting Removal 7
Data Validation/Conditional Formating 3
format cells depending on value range 5
Excel Conditioning Formatting 3
How can I set more than 3 conditions for cells? 2
condition format 2

Back
Top