LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default conditional formating with isodd and iseven

I have consective numbers in column A. In column B is formula =isodd
which returns True or False, and this works for me but I have tried to
use =isodd and =iseven as a conditional format formula with no luck.
My question is, is it possible to use either of these arguments in a
conditional format formula. I have tried severial syntax with no luck.
I most often get error message "May not use referance to other sheet
or book...." I know you guys can crack this.

Regards

BigD


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ISODD and EVEN formula BSantos Excel Worksheet Functions 6 January 18th 06 04:28 PM
cannot use ISEVEN or ISODD functions in Conditional Formatting Scott Paine Excel Worksheet Functions 6 December 6th 05 09:44 PM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 05:49 PM
ISEVEN SimonW Excel Worksheet Functions 4 March 26th 05 05:01 PM
IF and ISODD Formula Help vgolfman Excel Worksheet Functions 2 October 28th 04 03:07 PM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"