Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i want to set conditional format to cells containing odd numbers
i want to set conditional format to cells containing odd numbers
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i want to set conditional format to cells containing odd numbers
1. Select the cell/Range (say A1:A10). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =MOD(A1,2) 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. -- If this post helps click Yes --------------- Jacob Skaria "ian c" wrote: i want to set conditional format to cells containing odd numbers |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i want to set conditional format to cells containing odd numbers
Use this as CF formula:
=MOD(A1,2)0 Regards, Stefi €žian c€ť ezt Ă*rta: i want to set conditional format to cells containing odd numbers |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i want to set conditional format to cells containing odd numbers
Hi,
Click on the first cell (say A5) press Alt+O+D. In Excel 2003, select Formula is in the drop down. In Excel 2007, press New Rule and select the last rule type. In the formula bar type =isodd(a5) and then click on the format button to select the desired format. Now click on OK Apply OK. Copy and past the conditional formatting by using the paint brush -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "ian c" wrote in message ... i want to set conditional format to cells containing odd numbers |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i want to set conditional format to cells containing odd numbers
1. Place the cursor in A1 cell and select the Range
2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and paste the below formula =A1=ODD(A1) 4. Click Format ButtonFontColor select your desired font & Background Color pattern and then give ok Change the cell reference of A1 to your desired cell, if required. But keep in mind that when applying the conditional formatting the Active cell should be in the cell on which the formula is referred. For Example if you want to apply the conditional formatting for C Column when the formula is referring the C2 cell then place the cursor in C2 cell and select the whole C Column by pressing Cntrl+Spacebar and apply the below formula. =C2=ODD(C2) If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- -------------------- (Ms-Exl-Learner) -------------------- "ian c" wrote: i want to set conditional format to cells containing odd numbers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I conditional format using a range of numbers | Excel Discussion (Misc queries) | |||
Conditional format for 5 numbers | Excel Discussion (Misc queries) | |||
Conditional format numbers | Excel Worksheet Functions | |||
Conditional Format for Numbers | Excel Discussion (Misc queries) | |||
How do I do a conditional format for numbers | Excel Worksheet Functions |