Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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_ | |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
Conditional Formatting based on Formula | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions |