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
|