Formatting Cells using an If Statement
 

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

Formatting Cells using an If Statement
 

You cannot change font characteristics using a formula: a formula will only
put a value (number/text) in a cell.

"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

Formatting Cells using an If Statement
 

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

Formatting Cells using an If Statement
 

Thanks. I was afraid of that (but was hoping there might be some way to
access the logic the conditional formatting wizard uses or something...)

"Toppers" wrote:

You cannot change font characteristics using a formula: a formula will only
put a value (number/text) in a cell.

"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

Formatting Cells using an If Statement
 

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

Formatting Cells using an If Statement
 

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