Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 8th 08, 07:15 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,560
Default Display conditional formatting if cell value equals an integer

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?

  #2   Report Post  
Old June 8th 08, 07:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
display contents of cell if adjacent cell equals Travis Excel Worksheet Functions 1 June 7th 08 02:34 PM
integer with decimal display oldLearner57 Excel Discussion (Misc queries) 1 July 3rd 07 12:30 PM
Conditional Formatting that will display conditional data BrainFart Excel Worksheet Functions 1 September 13th 05 05:45 PM
Why won't my conditional formatting display in the cell Cashius War eagle Excel Discussion (Misc queries) 3 February 15th 05 08:38 PM
have cell display the word balance when a equals the same amount a jenniss Excel Discussion (Misc queries) 8 February 6th 05 05:06 PM


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017