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!

Advanced conditional formatting
 

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!

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!

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!