Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced conditional formatting
I have a cell with a drop down box with options "Yes" or "No". If "Yes" is
selected, is it possible to apply a format to OTHER cells? For example, make the text or cell(s) grey to show that no input data is required for these? Conditional formatting only applies the format depending on the value in that particular cell. For example: Cell A1 has a drop down box, a choice between "Yes" and "No". If "No" is selected, the user inputs data into cells A2 and A3, and cells A4 and A5 contain formulae. If "Yes" is selected in cell A1, I want to make cells A2 - A5 grey to show these cells should be ignored. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced conditional formatting
That's exactly what I was after. You learn something new every day. Thanks
for you help! "Sandy Mann" wrote: Conditional formatting only applies the format depending on the value in that particular cell. That is not true. The formula in the Conditional formatting should resolve to a TRUE or FALSE but it can refer to other cells, for example: =$A$1="yes" and selecting a grey pattern -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "oli_qld" wrote in message ... I have a cell with a drop down box with options "Yes" or "No". If "Yes" is selected, is it possible to apply a format to OTHER cells? For example, make the text or cell(s) grey to show that no input data is required for these? Conditional formatting only applies the format depending on the value in that particular cell. For example: Cell A1 has a drop down box, a choice between "Yes" and "No". If "No" is selected, the user inputs data into cells A2 and A3, and cells A4 and A5 contain formulae. If "Yes" is selected in cell A1, I want to make cells A2 - A5 grey to show these cells should be ignored. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced conditional formatting
You're very welcome. Thanks for the feedback.
-- Reagrds, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "oli_qld" wrote in message ... That's exactly what I was after. You learn something new every day. Thanks for you help! "Sandy Mann" wrote: Conditional formatting only applies the format depending on the value in that particular cell. That is not true. The formula in the Conditional formatting should resolve to a TRUE or FALSE but it can refer to other cells, for example: =$A$1="yes" and selecting a grey pattern -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "oli_qld" wrote in message ... I have a cell with a drop down box with options "Yes" or "No". If "Yes" is selected, is it possible to apply a format to OTHER cells? For example, make the text or cell(s) grey to show that no input data is required for these? Conditional formatting only applies the format depending on the value in that particular cell. For example: Cell A1 has a drop down box, a choice between "Yes" and "No". If "No" is selected, the user inputs data into cells A2 and A3, and cells A4 and A5 contain formulae. If "Yes" is selected in cell A1, I want to make cells A2 - A5 grey to show these cells should be ignored. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter by Cell Formatting | Excel Worksheet Functions | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
Advanced formatting operation on a cell | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional Format Advanced | Excel Worksheet Functions |