i want to set conditional format to cells containing odd numbers

  • Thread starter Thread starter ian c
  • Start date Start date
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 Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=MOD(A1,2)

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New rule>Use a formula to determine which cells to
format. Enter the formula in the box below.
 
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
 
1. Place the cursor in A1 cell and select the Range
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and paste the below formula
=A1=ODD(A1)
4. Click Format Button>Font>Color 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!
 
Back
Top