conditional formatting

  • Thread starter Thread starter traci
  • Start date Start date
T

traci

I have 3 columns 1) is the order quanity 2)is the box 3)is the # of
boxes
If it is not even boxes it will come up as a decimal. I want my
decimal numbers to come up in red . How can i do this
 
Hi traci,

Use conditional formatting to do this. Select the range of
cells that you want to format in this manner. Go to
Format>Conditional Format. Select Formula Is and enter
this formula:

=A1<>INT(A1)

Adjust the actual references to meet your needs.
Select the format styles that you would like then OK out.

Biff
 
Go to Format, then conditionbal format, then select "cell
value is", then change "between" to "equal to", then type
a decimal in the next box.
 
Hi Michael,

That would not work in this situation. If you use the
value of say .2 in your example, then the cell with the
conditional format must be 'exactly equal to' .2 for the
format to be applied. Although the OP didn't say, I
assumed the decimals could be *any* decimal value.

Biff
 
Back
Top