Shading whole row based on value in one column

Use Conditional Formatting.

Regards, TMS

Use Conditional Formatting

Assuming row A should be shaded based on A1 being "ABC"...

Select the cells on row A you want shaded.

Conditional Formatting
New Rule
Use a formula to determine...

=($A$1="ABC")
format as required.

Use Format painter to copy the format to other rows.

@Special-K: rows are usually referred to by number and columns by alphabet so it's a little confusing if you transpose them.

But to build on the suggestion, you could select all the rows and columns at once and then use the formula:

Formula:

Please Login or Register  to view this content.

Regards, TMS

Good point, I meant row 1 not row A

Clear the Conditional Formatting you already have.

Select ALL the cells you want to change colour on your selected row
formula
=($A1="ABC")
and format as required

ALL the cells you selected should change colour when that condition is true.

I think you need to remove the second $
so it's like

$A1
rather than
$A$1

Then use Format painter

Yes, it's

Formula:

Please Login or Register  to view this content.

as opposed to

Formula:

Please Login or Register  to view this content.

and you don't need the brackets so

Formula:

Please Login or Register  to view this content.

And, as I said, if you use that formula, you can select all the rows and columns starting with cell A1 and apply the formatting in one go.

As Special-K suggested, it would be a good idea to check and, if necessary, remove any other CF affecting those cells.

Regards, TMS