Conditional Formatting formula not acceptable?
I'm trying to Conditional Format a number of cells using "Formula Is" &
"=ISODD(INT($f2))=True", ie. if the value in F2 is odd, format the data. I
keep getting the message "You may not use references to other worksheets or
workbooks for Conditional Formatting Criteria". Why am I getting this error?
I used this formula instead:
=MOD($F358,2)<0
But was interested to know why my original wasn't acceptable.
XL2003
WinXPSP2
--
|
+-- Thief_
|
|