Thread: i want to set conditional format to cells containing odd numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default 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

Reply With QuoteReply With Quote