Conditional Format 1

[binaryfingers]

Hi

I have a table that has 5 columns in it by 25 rows.

In the 3rd column, are company names.

Based on the cell matching the criteria of the company name, is there a way of changing the background colour of the 5 columns for that one row.

Eg

I have been able to set conditional format so that the company name when equals MJSA, turns the background red, using a simple cell equals MJSA conditional format. For demo lets say this is row 5.

Is there a way then to get column 1, column 2, column 4 and column 5 for that same row (row 5) to then also have a red background because the company name is a match?

The reason behind this is the table updates each month and the different company names/data can move up and down the table each time and it saves having to constantly change the highlighted cells.

Thanks,

 

[SkipVought]

Hi,

Select the entire table of data. Assuming that the data starts in A2...
[tt]
Formula Is: =$C2="MJSA"
[/tt]


Skip,

_[red][/red]

 

[binaryfingers]

Excellent! Thanks Skip,