ExcelBanter - Coloring

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Coloring (https://www.excelbanter.com/excel-worksheet-functions/260714-coloring.html)

Elton Law[_2_]

Coloring

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[_2_]

Coloring

Only with VBA. See
http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Elton Law" wrote in message
...
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

Jim Thomlinson

Coloring

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

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

Jim Thomlinson

"Elton Law" wrote:

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

All times are GMT +1. The time now is 08:02 PM.