Conditional Formatting Question

[The Shadowman]

Hi All

I have a problem conditionally formatting a column of cells. BQ31:BQ49. One of these cells contains the word “Average” and moves up and down as data is received. I want to make the word red which I have done with CF. However, when the word moves to another cell it loses its format and goes back to black. Is there a way to make the formatting move with the word? Many thanks Robert

 

[SanjayGMusafir]

Can you share a screenshot of conditional formatting rules to understand the scenario.

 

[The Shadowman]

The column contains a list of players that move up and down as their scores change. Consider "AVERAGE" to be just another player , but I want him to be in red. If I format the "AVERAGE" cell to red text, when it moves up and down it loses the red formatting. How can I make the red move with the word? Many thanks for your reply and help. Robert

 

[SanjayGMusafir]

The column contains a list of players that move up and down as their scores change. Consider "AVERAGE" to be just another player , but I want him to be in red. If I format the "AVERAGE" cell to red text, when it moves up and down it loses the red formatting. How can I make the red move with the word? Many thanks for your reply and help. Robert

screenshot of conditional formatting rules to understand the scenario

Need screenshot of conditional formatting rules, not the formatted column...

 

[The Shadowman]

Thank you. I have managed to solve the problem. I had been using the wrong CF rules. Thank you Robert

 

[SanjayGMusafir]

Thank you. I have managed to solve the problem. I had been using the wrong CF rules. Thank you Robert

That is what I was trying to mention. Good it got sorted out.