conditional formatting excel

  • Thread starter Thread starter student
  • Start date Start date
S

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
 
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.
 
THANK YOU FOR RESPONDING SO QUICKLY - I AM SURE I WILL LEARN MORE BY
FOLLOWING YOUR LINKS.

S
 
Back
Top