Home |
Search |
Today's Posts |
#1
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? |
#2
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 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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display contents of cell if adjacent cell equals | Excel Worksheet Functions | |||
integer with decimal display | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) |