SEARCHING RANGE

[Mickey Mouse]

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

 

[Per Jessen]

Hi

Use Conditional Formatting.

Select range(A1, AZ100) > Format > Contitional Formatting > "Cell
Value is" "Equal to" > Enter value or cell reference > Click "Format"
and choose the format color desired.

Regards,
Per

 

[T. Valko]

Use conditional formatting....

Use a cell to enter the number you want to find. Let's say you use cell
A102.

Select your range of numbers A1:AZ100
Goto the menu Format>Conditional Formatting
From the drop down select Formula Is
Enter this formula in the box on the right:

=AND(A1<>"",A1=$A$102)

Click the Format button
Select the Patterns tab
Select a fill color
OK out

If the number you enter in A102 matches any numbers in the range A1:AZ100
those cells will be highlighted.

 

[Mickey Mouse]

Use conditional formatting....

Use a cell to enter the number you want to find. Let's say you use cell
A102.

Select your range of numbers A1:AZ100
Goto the menu Format>Conditional Formatting
From the drop down select Formula Is
Enter this formula in the box on the right:

=AND(A1<>"",A1=$A$102)

Click the Format button
Select the Patterns tab
Select a fill color
OK out

If the number you enter in A102 matches any numbers in the range A1:AZ100
those cells will be highlighted.

Thanks Biff,
It works fine, but I don't understand the formula.
If I was to write this in plain english, what is the formula saying?
You have given me the answer, now I'd like to understand what the answer
means.
Would you please break it down in plain english?
I remember my first computer, a COCO (which I still have). I learn't basic
programming with it.
Basic, in those days very much resembled english. A far cry from todays
programming... lol

Mickey

 

[T. Valko]

Thanks Biff,
It works fine, but I don't understand the formula.
If I was to write this in plain english, what is the formula saying?
You have given me the answer, now I'd like to understand what the answer
means.
Would you please break it down in plain english?
I remember my first computer, a COCO (which I still have). I learn't
basic programming with it.
Basic, in those days very much resembled english. A far cry from todays
programming... lol

Mickey

Would you please break it down in plain english?
=AND(A1<>"",A1=$A$102)

In plain English:

Cell A1 is not empty *AND* the value in cell A1 is the same as the value in
cell A102

Cell A1 is not empty: A1<>""

The value in cell A1 is the same as the value in cell A102: A1=$A$102

The result of the formula is either TRUE or FALSE. If both conditions are
TRUE then the fill color is applied to the cell. If either condition is
FALSE then the fill color is not applied.