Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eyeman6513_2000@yahoo.com - 31 Jul 2006 20:47 GMT

I have a spreadsheet that I need to apply conditional formatting on in
which I have four values: Over 85
Refused
Surgery
NULL

For the report cell to be coded a certian way, I can not get Excel to
get past three, all this is one format, any suggestions????

Reply to this Message

Gord Dibben - 31 Jul 2006 21:08 GMT

You are limited to three.

Use the default formatting for one of the values and CF for the other three
values.

See Bob Phillips' site for an Add-in which allows many more formats.......30
total.

http://www.xldynamic.com/source/xld.CFPlus.Download.html

Gord Dibben MS Excel MVP

>I have a spreadsheet that I need to apply conditional formatting on in
>which I have four values: Over 85
[quoted text clipped - 4 lines]
>For the report cell to be coded a certian way, I can not get Excel to
>get past three, all this is one format, any suggestions????

Reply to this Message

Rate this thread: