Prev: Data moving 3
Next: Weeknum formula
From: Elton Law on 5 Apr 2010 10:04
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
From: Bernard Liengme on 5 Apr 2010 10:16
Only with VBA. See
http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Elton Law" <EltonLaw(a)discussions.microsoft.com> wrote in message
news:D9EC9894-39AA-43A1-82CD-CFFE0A93B651(a)microsoft.com...
> 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

From: Jim Thomlinson on 5 Apr 2010 10:22
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
 | 
Pages: 1
Prev: Data moving 3
Next: Weeknum formula