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,