Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |