Conditional formatting to whole numbers

I have a sheet with decimal places on it but I would like to highlight the numbers based on the whole number, ignoring the decimals. For example:

5.3 5.2 4.5 6.3 5.5

If 5.3 is the reference cell, I would like to format the other cells to appear red if they are not 5.X. So the 4.5 and 6.3 would appear red while the 5.2 and 5.5 would remain black.

PS. I am an amateur so I don't know a lot of the lingo. Talk to me like I'm 10 years old :P

Thanks.

Tell us a bit more about your sheet, then. Do your numbers go across the sheet in one row, or do they go down the sheet in one column? Which cells are used? (e.g. from A2 to A20).

Pete

The reference cells run down from P2 - P229 and I want to format each row individually to the value in P. The cells I want to format run from column Q to AV.

Okay, select (highlight) all the cells from Q2 to AV229 first, and then click on Conditional Formatting | New rule and select Use a formula ... from the bottom of the list. In the dialogue box that pops up, put this formula in the formula box:

=INT(Q2)<>INT($P2)

then click on the Format button in the dialogue box, choose the Font tab (as it is the foreground colour that you want to change) and click on the Color drop-down and choose red. Then click OK twice to exit the dialogue box, and Excel will automatically apply that rule to the selected cells, making appropriate adjustments to the formula.

Hope this helps.

Pete

Thanks for the help! I am caught up in something else right now so I will try it out tomorrow and let you know.