conditional formatting
 

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

conditional formatting
 

Hi,

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

Mike

"Dave Eade" wrote:

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

conditional formatting
 

Hi

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

eg: =$a$1="yes"

regards
rajesh

"Dave Eade" wrote:

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

conditional formatting
 

Thanks Mike.

David

"Mike H" wrote:

Hi,

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

Mike

"Dave Eade" wrote:

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