Conditional formatting
 

Formula:- =IF(T3<=R3,"No","Yes")

Could some please tell me how to make the yes turn red in the cell. I am
using excel 2003

Thanks
--
Clare

Conditional formatting
 

Hi,
Highlight the column where the yes and no are, then conditional formating,
text that contains enter "YES"

"Clare" wrote:


Formula:- =IF(T3<=R3,"No","Yes")

Could some please tell me how to make the yes turn red in the cell. I am
using excel 2003

Thanks
--
Clare

Conditional formatting
 

Hi Clare

Select the cells to be formatted; Choose FormatConditional
Formatting..Select 'Cell Value Is' and enter 'Yes' and select a color

Refer the below link for detailed help

http://www.contextures.com/xlCondFormat01.html

If this post helps click Yes
---------------
Jacob Skaria


"Clare" wrote:


Formula:- =IF(T3<=R3,"No","Yes")

Could some please tell me how to make the yes turn red in the cell. I am
using excel 2003

Thanks
--
Clare