Conditional Formatting for Current Row

[Marmit424]

Hi!

I'm trying to get Excel to apply conditional formatting to each row based on the first columns text. It will need to check all rows because the selections will change. Ex:

Title	Column 1	Column 2	Column 3	Column 4
Selection 2	Needs input here	Needs Input Here
Selection 5			Needs Input Here	Needs Input Here

<tbody>
</tbody>

Is there an efficient way to get Excel to do this? Thank you!

 

[Joe4]

Sure, just apply it to the whole range, and write the formula as it applies to the first column (lock it down using absolute cell referencing, i.e. $A2).

If you need more help, please explain EXACTLY what you are trying to do in more detail.

 

[Marmit424]

Thank you Joe! Going to think this through a bit more and experiment and I'll circle back!

 

[seekerarcane]

Please do the following;

1. Select the whole table or cell references

2. Go the CF, >New Rules > Format only cells that contains

3. Select > Cell Value > Equals to > and in Reference bar click on your table's First Cell ( it will automatically be a ABSOLUTE Reference Cell)

4. Click on Format and choose the color and Press OK