|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 8th 08, 07:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
| Ads |
|
#2
June 8th 08, 07:27 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 tab>Styles>Conditional Formatting>New Rule>Use 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?
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Linear Mode
