Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want Excel to check a range of cells (A1,AZ100) for a specific entry and
then fill that cell with a color without changing the entry. Cells A1 to AZ100 contain randomized numbers betwwen 1 and 50. I'd like to search this range for a specific number I choose, I suppose using the 'search function' and 'find in this document' feature. Then fill that cell with a color. In short, search a range, find the target cell and fill it. I'm using Excel 2002 and my knowlegde using it less than limited. Can someone help me out here? Mickey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Searching a range with MS Query | Excel Worksheet Functions | |||
Entering a range of numbers and searching same | Excel Discussion (Misc queries) | |||
searching a range for a sum... | Excel Worksheet Functions | |||
Searching a Range for a number over 40 | Excel Worksheet Functions | |||
3d range searching | Excel Discussion (Misc queries) |