Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting dependent on another cell
I want to be able to "grey out" names in a list dependent on the numeric
content of an adjacent cell. Is there a way of using conditional formatting to do this? I have tried using - "Cell Value Is =A1=1" and it doesn't work. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting dependent on another cell
Sorry - have just figured it out ("Formula Value is" rather than "Cell Value
is"). Whoops. "Martin Ledgard" wrote: I want to be able to "grey out" names in a list dependent on the numeric content of an adjacent cell. Is there a way of using conditional formatting to do this? I have tried using - "Cell Value Is =A1=1" and it doesn't work. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting dependent on another cell
Hi Martin,
=A1=1 -- Regards, OssieMac "Martin Ledgard" wrote: I want to be able to "grey out" names in a list dependent on the numeric content of an adjacent cell. Is there a way of using conditional formatting to do this? I have tried using - "Cell Value Is =A1=1" and it doesn't work. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting dependent on another cell
Hi again,
I should have said to select formula and insert the formula I gave you. -- Regards, OssieMac "Martin Ledgard" wrote: I want to be able to "grey out" names in a list dependent on the numeric content of an adjacent cell. Is there a way of using conditional formatting to do this? I have tried using - "Cell Value Is =A1=1" and it doesn't work. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Data Validation - Dependent Lists & Conditional Formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional count of rows dependent on multiple columns | Excel Worksheet Functions |