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

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
.

Shading a row red as soon as a cell entry in column L says "Error"
 

Select A1:Z30000
Using conditional formatting with rule: =$K1="Error"
Note the use of the $
Had your selection started with A21 then you would use =$K21="Error"
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

"andreashermle" wrote in message
...
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

Shading a row red as soon as a cell entry in column L says"Error"
 

On Feb 22, 7:15*pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
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
.- Hide quoted text -

- Show quoted text -

Dear Jim,

thank you very much for your superb help. It works as desired.
Just being curious. How would the macro solution look like?
Regards, Andreas

Shading a row red as soon as a cell entry in column L says"Error"
 

On Feb 22, 7:26*pm, "Bernard Liengme"
wrote:
Select A1:Z30000
Using conditional formatting with rule: =$K1="Error"
Note the use of the $
Had your selection started with A21 then you would use =$K21="Error"
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

"andreashermle" wrote in message

...



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- Hide quoted text -

- Show quoted text -

hey Bernard,
thank you very much for your superb help. It works as desired.
Just being curious. How would the macro solution look like?
Regards, Andreas