Excel's behaviour won't change just because you changed news groups.

Answer is still "cannot be done by formula"


Gord Dibben MS Excel MVP

On Thu, 6 Sep 2007 08:34:05 -0700, Seanb
wrote:

I posted this question once today in the general Excel group, but am
reposting here just in case someone might have some info. Sorry if you read
this already. I tried to cross-post here and it didnt work originally...

I am wondering if anyone knows, is there a way to format a cell based on
it's value using an IF statement? For example I want to enter a worksheet
function that would change a cells font color to red if it exceeds a certain
value.

=if(A22, change fornt to red, do nothing)

I am not looking to do this in VBA do to the various range sizes and shapes
that i would have to reference (would be a nightmare), and I dont want to use
conditional formatting either. It would be fine and easy to use conditional
formatting, but the cells I am trying to evaluate are on different tabs (wont
let me link the formula to other tabs), and the structure of spreadhseet is
such that there are literally hundreds maybe thousands of cells that this
should be applied to. It will be no small task to try and use the
conditional formatting wozard, lets put it that way.

Ideally, I would just like to have a simple IF function that I can copy and
paste and find and replace get other people here to use also.

Is there anyway to do this via an IF and skip the conditional formatting
wizard? Any help is greatly appreciated!

BTW - I am using Excel 2000