format color without conditoinal formating
 

Is there any way to change a background color or font color in a formula,
without using conditional formating. I am currently using a 2003 version and
Conditional formating is limited.
--
Thank you

format color without conditoinal formating
 

No. A formula can only return a value, not a format.

Pete

On Aug 5, 11:35*pm, WT wrote:
Is there any way to change a background color or font color in a formula,
without using conditional formating. *I am currently using a 2003 version and
Conditional formating is limited.
--
Thank you

format color without conditoinal formating
 

http://www.xldynamic.com/source/xld.....Download.html

--


Regards,


Peo Sjoblom

"WT" wrote in message
...
Is there any way to change a background color or font color in a formula,
without using conditional formating. I am currently using a 2003 version
and
Conditional formating is limited.
--
Thank you

format color without conditoinal formating
 

You can use an Event macro that can adjust the background color depending
upon the cell's value.
--
Gary''s Student - gsnu200797


"WT" wrote:

Is there any way to change a background color or font color in a formula,
without using conditional formating. I am currently using a 2003 version and
Conditional formating is limited.
--
Thank you