View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BIG D BIG D is offline
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