| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change conditional formatting if the number is odd or even?
How do I do a conditional formatting option based on if the number in the referenced cell is odd or even? For example, if the cell is 16, text color it black, if the cell is 15, text color it red.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change conditional formatting if the number is odd or even?
How do I do a conditional formatting option based on if the number in the
referenced cell is odd or even? For example, if the cell is 16, text color it black, if the cell is 15, text color it red. Select the cells to be ConditionalFormatted, then use the following 'formula'... =ISODD() ...then set the Font color as desired. The even values will be the default color unless you set another rule otherwise using =ISEVEN(). -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#3
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) "GS" ???? ... How do I do a conditional formatting option based on if the number in the referenced cell is odd or even? For example, if the cell is 16, text color it black, if the cell is 15, text color it red. Select the cells to be ConditionalFormatted, then use the following 'formula'... =ISODD() ..then set the Font color as desired. The even values will be the default color unless you set another rule otherwise using =ISEVEN(). -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#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 |
| Reply |
| 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) | |||
Hybrid Mode
