| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change conditional formatting if the number is odd or even?
Information Adding:
Some version Excel can't use "ISODD" worksheet function directly, such as 2003. It needs to click menu "Tool"-"Add-in"-"Analysis tool", then you can use it. (Since I haven't English version, I don't what's exact name is.) If this operation still doesn't work, you can use mod instead of "ISODD" function. =MOD(A1,2) Yes, this is a better way! Thanks... -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting does not change when values change. ?? | Excel Worksheet Functions | |||
| How do I use Conditional Formatting to change pos No to a Neg No | Excel Discussion (Misc queries) | |||
| whole number conditional formatting | Excel Worksheet Functions | |||
| Change conditional formatting to coloured alternate rows dependent on a change in date? | Excel Programming | |||
| Conditional Number Formatting | Excel Discussion (Misc queries) | |||
![GS[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
