| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Row If Cell Contains Even Number
I'm creating a guest list.
On this list, persons living at the same address are given a common ID number, unique to that address. I enter this number in column A. For readability I want records for even-numbered households to have a format of my choosing. I tried using condidtional format by selecting all the rows and entering the formula like this: Formula is =ISEVEN($A1) This results in an error: "You may not use references to other worksheets or workbooks for Conditional Formatting criterea". What am I doing wrong? ]-[ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Row If Cell Contains Even Number
iseven does not appear to be a function on my version of Excel. Is it a UDF?
Regardless, the following appears to work: =MOD($A1,2)=0 "Ken Zenachon" wrote: I'm creating a guest list. On this list, persons living at the same address are given a common ID number, unique to that address. I enter this number in column A. For readability I want records for even-numbered households to have a format of my choosing. I tried using condidtional format by selecting all the rows and entering the formula like this: Formula is =ISEVEN($A1) This results in an error: "You may not use references to other worksheets or workbooks for Conditional Formatting criterea". What am I doing wrong? ]-[ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Row If Cell Contains Even Number
I see from another thread that iseven is in the analysis toolpak which I am
not using which is why it did not work when I tried it. "Kleev" wrote: iseven does not appear to be a function on my version of Excel. Is it a UDF? Regardless, the following appears to work: =MOD($A1,2)=0 "Ken Zenachon" wrote: I'm creating a guest list. On this list, persons living at the same address are given a common ID number, unique to that address. I enter this number in column A. For readability I want records for even-numbered households to have a format of my choosing. I tried using condidtional format by selecting all the rows and entering the formula like this: Formula is =ISEVEN($A1) This results in an error: "You may not use references to other worksheets or workbooks for Conditional Formatting criterea". What am I doing wrong? ]-[ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying number format from referenced cell | Excel Discussion (Misc queries) | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
