View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default whole number conditional formatting

Use this formula in your Conditional Formatting:

=MOD(A1,1)<0

Where cell A1 is the cell where your formula is located.

HTH,
Elkar


"danlinksman" wrote:

I would like the cell to turn a highlight color if the result of a particular
formula is not a whole number.