Thread
:
Conditional formatting error
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Conditional formatting error
use mod or this from Gord Dibben
=ROW()=ODD(ROW())
--
Don Guillett
SalesAid Software
wrote in message
ups.com...
Hi,
To create an odd/even shaded table I want to use conditional formatting
with the following formula: =isodd(row())
However, this produces an immediate error "You may not use references
to other worksheets or workbooks for Conditional Formatting criteria".
I can put this formula in a separate cell and then use =A$5 for the
formula in the conditional formatting dialog and it works fine, but
putting the =isodd(row()) formula always causes this error.
Is this a bug, or is there a real reason I can't use this formula?
(I'm using Excel 2000, ver 9.0.7616 SP-3)
--
fishter
Reply With Quote