Conditional Formatting

[Guru]

Hello All,

I am beginner in excel. I just wanted to know, is there any method to have
more than three conditions in conditional formatting.

Thanks in advance
Vinay

 

[blackbox via OfficeKB.com]

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

this is a free add-in that allows upt to 30 conditional formats

 

[Guest]

Not that I know of, but you could use an additional cell with a formula to
compound the logic for one or more of your conditional formats.

When you enter the conditional formats dialog you can change "Cell value Is"
to "Formula Is", this then allows you to point to another cell.

E.g. lets say I want to format D11, in the C/F dialog change to "formula is"
and enter "=$E$11=TRUE" (no quotes), and choose a format, hit OK. SO now the
format of D11 is dependant on E11 being = true. IN cell E11 you can now
construct a formula much more complex. ALternativelty you can actually
encapsulate this logic in the conditional formatting input box itself e.g.

=AND(E11>3,F11<5)