What is the difference between absolute reference and relative cell reference?

[byron_m]

How does absolute reference differ from relative cell reference?

 

[Fluff]

Hi & welcome to MrExcel.
Have a look here

Excel cell references - relative & absolute references in conditional formatting rules

Invest a few minutes and learn how to correctly use relative and absolute cell references in Excel conditional formatting rules. This knowledge will certainly save you far more time in the long run.

www.ablebits.com