|Posted: February 27, 2011, 8:24 pm - IP Logged|
Here is the formula:
You have to set up the excel sheet first by adding the #'s in the specified column. In the example I used column A. Then in the next column you have to put the range of numbers you want. In the example I used 0-9.
Once you do that highlight the #s in column B and then click on "Format" in Excel, and then "Conditional Formatting". Once you are there, under "Condition 1" select "Formula is" and type that formula in. Once you do that, in the same box click on format and add the formatting you want. In the example I provided, I just made the selections with a yellow background. You can customize it anyway you want.
Also you may have to change the formula depending on which column/rows you are using. If you are using column A & B then the formula I provided will work
I hope I explained it clearly. If you have any questions let me know.
Not sure about having the results entered automatically into a different cell. Im sure its possible I just havent had a chance to work on it yet