Using IF or LOGICAL

Occasional Visitor

I want Excel to format cells that contain numbers that are less than full integer. Eg:

89.75 appears in a cell.

Next cell is 23.8.

I want those cells to be red. How do I conditionally format the cell?

2 Replies

@Walter8544 

Select the cells that you want to format conditionally.

In the following I will assume that A1 is the active cell in the selected range.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

 

=A1<>INT(A1)

 

or

 

=MOD(A1,1)

 

where A1 is the active cell.

Click Format...

Activate the Fill tab.

Select red.

Click OK, then click OK again.

 

@Walter8544 

 

mathetes_1-1612971596031.png