View Single Post
  #1   Report Post  
Thief_
 
Posts: n/a
Default 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_
|