Conditional format two cells if it meets a criteria

[Biz]

Dear All,

Using Excel 2010.

I am having problems conditionally format two cells if it meets criteria.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Looking at range (I73:J73). If (ABS(I73) =1, True, false). If True condition format green both cells I73: J23.<o></o>
Currently it only work for first cell only<o></o>
<o></o>
I need to go it over multiple columns.<o></o>
<o></o>
For instance, E11:F11, G54:H54, K80:L80, M99:N99,O142:P142,Q167:R167,S192:T192.<o></o>
<o></o>
<o>Critera</o>
<o>* E11 =1 then CF E11:F11</o>
<o>* G54 =1 then CF G54:H54</o>
<o>* K80 =1 then CF K80:L80</o>
<o>* M99=1 then CF M99:N99</o>
<o>* O142=1 then CF O142:P142</o>
<o>* O167=1 then CF Q167:R167</o>
<o>* S192=1 then CF S192:T192</o>
<o></o>
<o>Your help would be greatly appreciated.</o>
<o></o>
<o>Kind Regards,</o>
<o></o>
<o>Biz</o>
<o></o>
<o></o>
<o></o>
<o></o>
<o></o>

 

[Andrew Poulsom]

Use a formula like:

=ABS($I73)=1

The $ sign fixes the column reference

 

[Biz]

Thanks.