Coloring

[Elton Law]

Dear Expert,
My office is still using Excel 2000.
Conditional format can go up to 3 only.
Is it possible to use if function to add more?
Say certain certeria are fulfilled then show up a color or change fonts ...?
Is it possbile?
Thanks

 

[Bernard Liengme]

Only with VBA. See
http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm

 

[Jim Thomlinson]

Here is one way to get an extra 3 formatted font colours...

http://www.mcgimpsey.com/excel/conditional6.html