To quote the OP

"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."



--
Regards,

Peo Sjoblom


"Michael" wrote in message
...
From the Main Menu Bar, select:
Format - Conditional Format
Follow the instructions on the pop up windows.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"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