Hi There,

I have the following question:

What if I have a drop down list....can I still set the cell/ column to
recognize the various color codes set? Example given below:

F = Fixed (want to reflect blue)
R = Rendering (want to reflect green)
N = Null (want to reflect yellow)
P = Pass (want to reflect grey)

My drop down menu has the options "F", "R", "N" and "P"....once someone
selects "F" or one of the other 3, can it be assigned the various colors
which I've listed above? I am desperately trying to have this automatically
color the cell once the code is selected.

Please advise....thank you!
~TKT


"Mladen_Dj" wrote:

Use all three conditions for your range (A:M), but in opposite direction you
write them here. It means in conditional formatting dialog for condition 1
select:
"Formula Is:" and put formula:
=$M10 (select Cell shading - No color),
click Add-, and in condition 2 put
"Formula Is:" and put formula:
=$J10 Cell Shading - Red),
click Add-, and in condition 3 put
"Formula Is:" and put formula:
=$A10 Cell Shading - Yellow)


"SCrowley" wrote in message
...
I am trying to get Conditional formatting to achieve a result to no avail.

Here is what I'd like it to do:

Column A - if cell, in Row is 0 then shade active Row
(ColumnA:ColumnM)YELLOW
THEN if cell in Column J is 0 then shade activated Row (ColumnA:ColumnM)
RED (this supersedes previous format of Yellow)
THEN if cell in Column M is 0 the remove all shading from active Row.

Column A logs in that something was received, Column J means the received
item was rejected and must be re-submitted, Column M is the close out
showing
final has been approved.

Can this be written as a formula or does this need VBA?

Thank you.

--
Thank you,