software

Hi,

I want to create a conditional format which will change the color of a cell
depending on the user's choice. The cells which I am referencing are
scattered througout the worksheet (i.e. E84, E88, E90, etc.) How can I set
this conditional format to multiple cells? Or is there a way to set the
conditional format to text within a cell? any suggestions would be greatly
appreciated.

Thank you,

I also wanted to inform you that the conditional format will be applied to a
dropdown list. I currently have the list on sheet 2, but apparently
conditional formatting does not function across multiple sheets.

quot;TCquot; wrote:

gt; Hi,
gt;
gt; I want to create a conditional format which will change the color of a cell
gt; depending on the user's choice. The cells which I am referencing are
gt; scattered througout the worksheet (i.e. E84, E88, E90, etc.) How can I set
gt; this conditional format to multiple cells? Or is there a way to set the
gt; conditional format to text within a cell? any suggestions would be greatly
gt; appreciated.
gt;
gt; Thank you,

Assuming that you have a limited number of choices in the cells to be
conditionally formatted (e.g. Yes, No, Maybe), you can set up the
conditionally formatting for one cell, then use the Format Painter to copy
the conditional formatting to the cells that you wish to apply the
formatting. Note that you can only set three conditional format levels per
cell (plus a nonconditional format for an entry that does not match any of
your conditions).

quot;TCquot; wrote:

gt; Hi,
gt;
gt; I want to create a conditional format which will change the color of a cell
gt; depending on the user's choice. The cells which I am referencing are
gt; scattered througout the worksheet (i.e. E84, E88, E90, etc.) How can I set
gt; this conditional format to multiple cells? Or is there a way to set the
gt; conditional format to text within a cell? any suggestions would be greatly
gt; appreciated.
gt;
gt; Thank you,

Thanks for the response... Here is what I am looking at.

I have 15 rows with entries in them. 7 of those fifteen are invalid
options. When a user selects one of the seven in Cell B30, I want the cell to
become red. The 7 invalid cells are not in a consecutive range and they are
also on sheet 2 of the workbook.quot;SVCquot; wrote:

gt; Assuming that you have a limited number of choices in the cells to be
gt; conditionally formatted (e.g. Yes, No, Maybe), you can set up the
gt; conditionally formatting for one cell, then use the Format Painter to copy
gt; the conditional formatting to the cells that you wish to apply the
gt; formatting. Note that you can only set three conditional format levels per
gt; cell (plus a nonconditional format for an entry that does not match any of
gt; your conditions).
gt;
gt; quot;TCquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I want to create a conditional format which will change the color of a cell
gt; gt; depending on the user's choice. The cells which I am referencing are
gt; gt; scattered througout the worksheet (i.e. E84, E88, E90, etc.) How can I set
gt; gt; this conditional format to multiple cells? Or is there a way to set the
gt; gt; conditional format to text within a cell? any suggestions would be greatly
gt; gt; appreciated.
gt; gt;
gt; gt; Thank you,

Thsat is a significantly more complex conditional formatting problem that you
originally implied. I'd suggest that you post your detailed description on
the Excel programming board.

quot;TCquot; wrote:

gt; Thanks for the response... Here is what I am looking at.
gt;
gt; I have 15 rows with entries in them. 7 of those fifteen are invalid
gt; options. When a user selects one of the seven in Cell B30, I want the cell to
gt; become red. The 7 invalid cells are not in a consecutive range and they are
gt; also on sheet 2 of the workbook.
gt;
gt;
gt; quot;SVCquot; wrote:
gt;
gt; gt; Assuming that you have a limited number of choices in the cells to be
gt; gt; conditionally formatted (e.g. Yes, No, Maybe), you can set up the
gt; gt; conditionally formatting for one cell, then use the Format Painter to copy
gt; gt; the conditional formatting to the cells that you wish to apply the
gt; gt; formatting. Note that you can only set three conditional format levels per
gt; gt; cell (plus a nonconditional format for an entry that does not match any of
gt; gt; your conditions).
gt; gt;
gt; gt; quot;TCquot; wrote:
gt; gt;
gt; gt; gt; Hi,
gt; gt; gt;
gt; gt; gt; I want to create a conditional format which will change the color of a cell
gt; gt; gt; depending on the user's choice. The cells which I am referencing are
gt; gt; gt; scattered througout the worksheet (i.e. E84, E88, E90, etc.) How can I set
gt; gt; gt; this conditional format to multiple cells? Or is there a way to set the
gt; gt; gt; conditional format to text within a cell? any suggestions would be greatly
gt; gt; gt; appreciated.
gt; gt; gt;
gt; gt; gt; Thank you,

So you are selecting a value from a dropdown list and if that value is one
of seven that belong to another list then you want to change colour? What
determines if a value is invalid? Meaning if you select an invalid value
where in the 15 rows list can you see that this is invalid, any rules like
greater than a certain numeric value or an invalid word?

--
Regards,

Peo Sjoblom

(No private emails please)quot;TCquot; gt; wrote in message
...
gt; Thanks for the response... Here is what I am looking at.
gt;
gt; I have 15 rows with entries in them. 7 of those fifteen are invalid
gt; options. When a user selects one of the seven in Cell B30, I want the cell
gt; to
gt; become red. The 7 invalid cells are not in a consecutive range and they
gt; are
gt; also on sheet 2 of the workbook.
gt;
gt;
gt; quot;SVCquot; wrote:
gt;
gt;gt; Assuming that you have a limited number of choices in the cells to be
gt;gt; conditionally formatted (e.g. Yes, No, Maybe), you can set up the
gt;gt; conditionally formatting for one cell, then use the Format Painter to
gt;gt; copy
gt;gt; the conditional formatting to the cells that you wish to apply the
gt;gt; formatting. Note that you can only set three conditional format levels
gt;gt; per
gt;gt; cell (plus a nonconditional format for an entry that does not match any
gt;gt; of
gt;gt; your conditions).
gt;gt;
gt;gt; quot;TCquot; wrote:
gt;gt;
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; I want to create a conditional format which will change the color of a
gt;gt; gt; cell
gt;gt; gt; depending on the user's choice. The cells which I am referencing are
gt;gt; gt; scattered througout the worksheet (i.e. E84, E88, E90, etc.) How can I
gt;gt; gt; set
gt;gt; gt; this conditional format to multiple cells? Or is there a way to set
gt;gt; gt; the
gt;gt; gt; conditional format to text within a cell? any suggestions would be
gt;gt; gt; greatly
gt;gt; gt; appreciated.
gt;gt; gt;
gt;gt; gt; Thank you,Hi

Could you not copy your 7 invalid entries to another area of your sheet
(or a different sheet) in a contiguous block and give this a name such
as quot;Invalidquot;?
Then in cell B30, your conditional format test becomes
=COUNTIF(Invalid,B30)gt;0

--
Regards

Roger Govierquot;TCquot; gt; wrote in message
...
gt; Thanks for the response... Here is what I am looking at.
gt;
gt; I have 15 rows with entries in them. 7 of those fifteen are invalid
gt; options. When a user selects one of the seven in Cell B30, I want the
gt; cell to
gt; become red. The 7 invalid cells are not in a consecutive range and
gt; they are
gt; also on sheet 2 of the workbook.
gt;
gt;
gt; quot;SVCquot; wrote:
gt;
gt;gt; Assuming that you have a limited number of choices in the cells to be
gt;gt; conditionally formatted (e.g. Yes, No, Maybe), you can set up the
gt;gt; conditionally formatting for one cell, then use the Format Painter to
gt;gt; copy
gt;gt; the conditional formatting to the cells that you wish to apply the
gt;gt; formatting. Note that you can only set three conditional format
gt;gt; levels per
gt;gt; cell (plus a nonconditional format for an entry that does not match
gt;gt; any of
gt;gt; your conditions).
gt;gt;
gt;gt; quot;TCquot; wrote:
gt;gt;
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; I want to create a conditional format which will change the color
gt;gt; gt; of a cell
gt;gt; gt; depending on the user's choice. The cells which I am referencing
gt;gt; gt; are
gt;gt; gt; scattered througout the worksheet (i.e. E84, E88, E90, etc.) How
gt;gt; gt; can I set
gt;gt; gt; this conditional format to multiple cells? Or is there a way to
gt;gt; gt; set the
gt;gt; gt; conditional format to text within a cell? any suggestions would be
gt;gt; gt; greatly
gt;gt; gt; appreciated.
gt;gt; gt;
gt;gt; gt; Thank you,