EXCEL - conditional format

  • Thread starter Thread starter FGM
  • Start date Start date
F

FGM

Is it possible to put more than 3 conditional formats?
I want to put around 8... If 0-5 blue, If 6-10 red, If
11 - 15 brown etc....
Thanks....
 
You'll find that you can't add more than 3 conditions. i.e. the answer to the OP's question is
No. You would have to use an event macro (maybe On_Calculate) to scan the cells and set the
colors if you need more than 3 conditions (plus the default).
 
Back
Top