conditional formatting rows with various cell values

[jjpcpanama]

Trying to conditional format a large excel worksheet with several rows.
Want to have row be a color if column G is 0.0, 0.1, 0.2 all the way to 0.7
Want column G with 0.8 to a different color.

Thanks a lot

[Richard Buttrey]

Hi,

See the attached.
I've used a ROUND function for the 0.8 rule since strictly speaking the underlying value of G14 is 0.778 not 0.8 although it's displayed as 0.8.

[etaf]

try a couple of conditional formatting rule
=AND($G1<>"",$G1<=0.7)
and
=AND($G1<>"",$G1=0.8)
OR did you want >0.7 ?
as G does not have 0.8

anyway , heres the sheet

[jjpcpanama]

Hi,

See the attached.
I've used a ROUND function for the 0.8 rule since strictly speaking the underlying value of G14 is 0.778 not 0.8 although it's displayed as 0.8.

I kinda get it but could not actually get it to work perfectly. Thanks.

[jjpcpanama]

Wayne.. I copied the formula and it worked.. I don't understand the formula.. but for now that is ok.. I am trying a couple of variations of it.. with different numbers. Thanks so much. I can always count on this forum.