Forum Discussion
Copying/Extending Conditional Formatting - Relative Cell Reference versus Absolute
Hi I apologize if this is a duplicate request. This is the first time I have used this forum. I thought I posted a request this morning but I do not see it. Here is my challenge. I have cond...
https://1drv.ms/u/s!Akyo43cv1NG3pE1E51Y3CMcNWwYL?e=6xgUQf
Hopefully this helps make my description more clear.
Thanks!
The 'Applies to' range will be absolute range references and that is fine. All that matters is the formula being used. So the formula is applied to the upper left corner cell of the 'Applies to' range. And THEN when it is 'applied to' every other cell in that range the formula is adjusted based on relative and absolute reference within that formula. So in your case you can change Applied to range to be $C$5:$F$100 and then with a formula like =C5>C4 it will apply that to cell C5 and then for C6 it will "apply" =C6>C5 and for D5 it will "apply" =D5>D4
alternatively if you always wanted to compare to the value in row 4 of the same column then you would use a formula like =C5>C$4 so that row 4 is fixed but the column is relative.
hope that helps
alternatively if you always wanted to compare to the value in row 4 of the same column then you would use a formula like =C5>C$4 so that row 4 is fixed but the column is relative.
hope that helps
- Thanks so much! I got it to work for me. I really appreciate the help!!!