Thread: Shading a row red as soon as a cell entry in column L says "Error"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andreashermle andreashermle is offline
external usenet poster
  
Posts: 123
Default Shading a row red as soon as a cell entry in column L says "Error"
Dear Experts:

I got a table that ranges from A1:Z3000. It has a named range
"DataList".
I would like those rows that have the expression 'Error' in Column 'K'
to acquire red shading.

How can this be achieved using a macro and / or conditional
formatting?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
Reply With QuoteReply With Quote