conditional formatting excel

[student]

I would appreciate some links on learning more about formulaes for
conditional formatting - I find it very interesting and would like to know a
wide range of things that it can do. thanks.

S

 

[Bob Umlas]

Try:
http://www.contextures.com/xlCondFormat01.html
for a starter...
Bob Umlas
Excel MVP

 

[Bernard Liengme]

Some links
http://www.contextures.com/xlcondFormat01.html
http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm

Find more by Goggling with search term "excel conditional formatting"
best wishes

 

[Shane Devenshire]

Hi,

You can Google "conditional formatting excel" and find hundreds of sites.

 

[T. Valko]

In short, you can use just about any kind of formula that evaluates to
either TRUE or FALSE, or, returns a numeric value. A formula that returns a
numeric value of 0 evaluates as FALSE, *any* other numeric value evaluates
as TRUE.

When the formula evaluates to FALSE, 0 or an error (like #N/A) the format is
not applied.

When the formula evaluates to TRUE or *any* number other than 0 the format
is applied.

The only limitation that I can think of is you can't use formulas that
contain array constants and the total length of the formula must not exceed
255 characters. However, you can get around those limitations by using
defined names.

Another interesting thing is that formulas used to apply conditional
formatting are automatically processed as array formulas.

 

[student]

THANK YOU FOR RESPONDING SO QUICKLY - I AM SURE I WILL LEARN MORE BY
FOLLOWING YOUR LINKS.

S