SEARCHING RANGE
 

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

SEARCHING RANGE
 

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

On 12 Apr., 03:27, "Mickey Mouse" wrote:
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

SEARCHING RANGE
 

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 FormatConditional 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.

--
Biff
Microsoft Excel MVP


"Mickey Mouse" wrote in message
...
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

SEARCHING RANGE
 

"T. Valko" wrote in message
...
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 FormatConditional 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.

--
Biff
Microsoft Excel MVP


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

SEARCHING RANGE
 

"Mickey Mouse" wrote in message
...

"T. Valko" wrote in message
...
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 FormatConditional 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.

--
Biff
Microsoft Excel MVP


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.



--
Biff
Microsoft Excel MVP