conditional formatting copy down

Trying to copy down a column the conditional formatting set in the first cell. Can not figure out why it wont work. When I enter my values that trigger thr formatting the whole column turns red instead of just the row that met the value?
Any help out there
Thanks

It is because of the absoultes.

You have $M$4

And you want $M4

Excel 101 - use of $ symbol to lock cell references.

$M$4 = Row locked at row 4 (absolute, won't change), column locked at column M (absolute, won't change)
$M4 = Row NOT locked (relative, will change when copied), column locked at column M (absolute)
M$4 = Row locked at row 4(Absolute), column NOT locked at column M (relative, will change when copied)
M4 = Row NOT locked (relative), column NOT locked (relative)


So, in your CF formulas, take out the $ in front of the 4 before copying.

works like a charm...i am only on lesson 21 havnt made it to 101 yet