View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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