I used this formula instead:
=MOD($F358,2)<>0
But was interested to know why my original wasn't acceptable.
XL2003
WinXPSP2
--
|
+-- Thief_
|
It's not built into excel.
--
Dave Peterson
--
|
+-- Thief_
|
"Dave Peterson" <pete...@verizonXSPAM.net> wrote in message
news:42DC59F9...@verizonXSPAM.net...
Personally, I would use MOD but you can use functions from ATP if you use
them in association with a defined name.
Insert>Name>Define
Name: Odd
Refers to: =ISODD(Sheet1!$A$1)
Then
Conditional Formatting
Formula is: =Odd
The only problem with this is that in the above situation using Named
formulas or ranges, you have to use absolute referencing so the above cf
formula will only work in a specific cell.....but there is a work around for
that....
You can use R1C1 referencing:
Insert>Name>Define
Name: Odd
Refers to: =ISODD(INDIRECT("RC",FALSE))
Now, when this used for the conditional formatting the named formula
references the cell that the cf is being applied to.
Biff
"Dave Peterson" <pete...@verizonXSPAM.net> wrote in message
news:42DC59F9...@verizonXSPAM.net...
--
Dave Peterson