View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Display conditional formatting if cell value equals an integer

Assume you want this to happen in cells A1:A10

Select the range A1:A10
Goto Home tabStylesConditional FormattingNew RuleUse a formula to
determine....

Format values where this formula is true:

=A1<INT(A1)

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"David" wrote in message
...
I want to set conditional formatting to display if the falue in a cell does
not equal an integer. How can I mmake that happen in Excel 2007?