i want to set conditional format to cells containing odd numbers
 

i want to set conditional format to cells containing odd numbers

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

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

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

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