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? ]-[ |
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 |