conditional formatting

D

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
 
M

Mike H

Hi,

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

Mike
 
R

rajesh

Hi

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

eg: =$a$1="yes"

regards
rajesh
 
Top