Shading a row red as soon as a cell entry in column L says "Error"
Select cells A1:Z3000
Select format | Conditional Formatting...
Select Formula is =$K1 = "Error"
Set your red format.
Ok
--
HTH...
Jim Thomlinson
"andreashermle" wrote:
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
.
|