I can't figure out of the following is possible and, if so, how to complete the task. I need to figure this out for a major project at work and any help is greatly appreciated! I am looking to complete the following conditional formatting to cell N1 with multiple rules. Basically, I am looking for white cell shading but the last populated row in a table needs to highlight gray. The one caveat it all values in the table show as values but are actually links to a 'master' document.
if N1 = 0 ..... THEN white cell/white text (blank)
OR
If N1 >0
and
if M1 >0
and
if O1 =0 .... THEN gray cell and black text
OR
If N1 >0
and
if M1 >0
and
if O1 >0 .... THEN white cell and black text
ANY help is greatly appreciated!!!!
Bookmarks