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,