Nope... Formulas return values. They do not manipulte the format of cells.
Why not use conditional formats???
--
HTH...

Jim Thomlinson


"Altec101" wrote:


Hello,

Is there a way I can change the font colour to red in the entire row
based on a value in a cell using an IF statment without using the
Conditional Formatting ?

Thanks,


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=546494