SOLVED

Conditional Formatting

Copper Contributor

I am using Conditional Formatting to fill colors in a row based on the text of one of the cells in that row.  There are two options that will be in the cell to be analyzed- Stub or Chain.  I want a the cells in the range of cells A:I to be blue for "Stub" and yellow for "Chain".  I have set up the formulas and formatting as I have done in the past, but now Excel is only formatting one of the cells in the range and not the whole range.

 

This is the Rules window I created:

ronmazz1959_0-1610046470217.png

 

This is the spreadsheet:

ronmazz1959_1-1610046516082.png

 

Is anyone else experiencing this?

 

4 Replies
best response confirmed by ronmazz1959 (Copper Contributor)
Solution

@ronmazz1959 

 

You just need to change the formula in the "Conditional Formatting Rules Manger" for both rules, just add the $ in front of the column name

=$H8="Chain"

=$H8="Stub"

con1.png

 

* If my post helped you, please click on like.

Thanks- that worked!

@ronmazz1959 

 

Glad it worked.

Hi all how do we copy and paste a conditional format with rules to another cell and update the rules accordingly automatically? I am having to go into each cell and manually update the rules to coloborate with the corresponding cell?
1 best response

Accepted Solutions
best response confirmed by ronmazz1959 (Copper Contributor)
Solution

@ronmazz1959 

 

You just need to change the formula in the "Conditional Formatting Rules Manger" for both rules, just add the $ in front of the column name

=$H8="Chain"

=$H8="Stub"

con1.png

 

* If my post helped you, please click on like.

View solution in original post