Jan 07 2021 11:11 AM
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:
This is the spreadsheet:
Is anyone else experiencing this?
Jan 07 2021 12:35 PM
Solution
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"
* If my post helped you, please click on like.
Sep 29 2021 02:55 AM
Jan 07 2021 12:35 PM
Solution
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"
* If my post helped you, please click on like.