|
|
Formula help for complex formatting.
I can't belive I didn't think of that. It's Friday and I'm going home!!!
THANK YOU THANK YOU THANK YOU
--
Thank you,
"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,
|