conditional formatting

[Dave Eade]

I want to format a cell based on the value of anither cell.

ie

If I9 = "yes" then format B9 as Bold Green

Anybody help - I've tried a few variation but can't get it to work.

Cheers

 

[Mike H]

Hi,

Select B9
Format|Conditional format
Select Formula is
Enter this formula
=I9="Yes"
Pick a colour
OK.

Mike

 

[rajesh]

Hi

under conditional formatting choose Formula Is and then refer the cell you
want to evaluate

eg: =$a$1="yes"

regards
rajesh

 

[Dave Eade]

Thanks Mike.

David

Hi,

Select B9
Format|Conditional format
Select Formula is
Enter this formula
=I9="Yes"
Pick a colour
OK.

Mike