Forum Discussion

Copper Contributor

Oct 19, 2024

Solved

Conditional Formatting not transposing

I wonder if someone would be kind enough to help me as I'm very much a semi-competent novice when it comes to this sort of thing! I'm attempting to copy and paste conditional formatting but when I do...

excel

Formulas and Functions

HansVogelaar
Oct 19, 2024
jmcintos

Edit each of the rules and change =$C$4 to =C4

HansVogelaar

MVP

Oct 19, 2024

jmcintos

Edit each of the rules and change =$C$4 to =C4

jmcintos

Copper Contributor

Oct 19, 2024

HansVogelaar THANK YOU SO MUCH!!!!! It was driving me crazy, I couldn't work out what I was doing wrong. I thought the $ did the opposite and kept it relative... if that's the correct term?

Thanks again, life saver!!!