[ms office - 2013] Excel Conditional Formatting

[callbe1]

Hi folks,

 

Does anyone know of a way to make one conditional formatting rule apply to multiple cells but based on different original cell values?

 

For instance:

 

(A1) 4.5 - 5 - 3 - 4.5

(A2) 3.5 - 5 - 3 - 3.5

(A3) 5.5 - 5 - 3 - 5.5

 

Can you create a formatting rule that applies to all the first column cells - A1:A3 - all I want is a greater than, equals too and less than. Obviously setting my table to do this for one set number is easy but to save time could it be different on each row all in one formatting rule.

 

Thanks for any help anyone can provide

[callbe1]

Fixed it!

 

Taking the $ lock out would have been a good idea. Instead of $A$1 just making it $A1 seems to have done it