Conditional Format Problem.
 

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick

In Conditional Formatting choose formula and enter
=COUNTIF($A$1:$A$11,$B$2)0
and set background color to green!

Regards,
Stefi

€žBig Rick€� ezt Ã*rta:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick

You could use this as your Conditional Format. Be sure to switch the
Condition drop-down to Formula Is.
=VLOOKUP($B$2,$A$1:$A$11,1,0)
Set the format to turn the cell green with the format button.

--
tj


"Big Rick" wrote:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick

Neither of these solutions are working.
Please can you help me further.

Thanking you in anticipation
--
Big Rick


"tjtjjtjt" wrote:

You could use this as your Conditional Format. Be sure to switch the
Condition drop-down to Formula Is.
=VLOOKUP($B$2,$A$1:$A$11,1,0)
Set the format to turn the cell green with the format button.

--
tj


"Big Rick" wrote:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick

Hi,

Select B2.
Under "Conditional Formatting",
Formula Is =ISNUMBER(MATCH($B$2,$A$1:$A$11,0))
Format the font color appropriately.

Regards,
B. R. Ramachandran

"Big Rick" wrote:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick

This does not seem to work either.
Have these formulas been tested?
I am eternally grateful for any help given, but if these work on another
computer, maybe it me doing something wrong. (Although I have got to grips
with CF before)

--
Big Rick


"B. R.Ramachandran" wrote:

Hi,

Select B2.
Under "Conditional Formatting",
Formula Is =ISNUMBER(MATCH($B$2,$A$1:$A$11,0))
Format the font color appropriately.

Regards,
B. R. Ramachandran

"Big Rick" wrote:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick

Hi,
Yes, I did test the formula before posting my reply.

I tried to mimic conditions where things could go wrong in CF.
Please check the CF formula; if by any chance the formula is enclosed
between double quotation marks, i.e., ="ISNUMBER(MATCH($B$2,$A$1:$A$11,0))",
remove the quotes, and see whether it helps.

If you inadvertently forgot to type the '=' sign when you entered the
formula the first time, Excel encloses the formula between double quotes,
and CF won't work. If you try again, the CF window WILL show an '=' sign at
the front. However, the double quotes will still be there and CF will not
work; and you can make it work by removing those quotes.

Regards,
B. R. Ramachandran


"Big Rick" wrote:

This does not seem to work either.
Have these formulas been tested?
I am eternally grateful for any help given, but if these work on another
computer, maybe it me doing something wrong. (Although I have got to grips
with CF before)

--
Big Rick


"B. R.Ramachandran" wrote:

Hi,

Select B2.
Under "Conditional Formatting",
Formula Is =ISNUMBER(MATCH($B$2,$A$1:$A$11,0))
Format the font color appropriately.

Regards,
B. R. Ramachandran

"Big Rick" wrote:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick

I have finally got it to work.
As I was at work and simply tried to type a few figures into a new
worksheet, I made the inexcusable mistake of putting the CF into cell B1!

I consider it an honour to be helped by you.
Your post on the six pointed star was absolutely brilliant. The best I've
ever seen.

<<<<<<
Big Rick


"B. R.Ramachandran" wrote:

Hi,
Yes, I did test the formula before posting my reply.

I tried to mimic conditions where things could go wrong in CF.
Please check the CF formula; if by any chance the formula is enclosed
between double quotation marks, i.e., ="ISNUMBER(MATCH($B$2,$A$1:$A$11,0))",
remove the quotes, and see whether it helps.

If you inadvertently forgot to type the '=' sign when you entered the
formula the first time, Excel encloses the formula between double quotes,
and CF won't work. If you try again, the CF window WILL show an '=' sign at
the front. However, the double quotes will still be there and CF will not
work; and you can make it work by removing those quotes.

Regards,
B. R. Ramachandran


"Big Rick" wrote:

This does not seem to work either.
Have these formulas been tested?
I am eternally grateful for any help given, but if these work on another
computer, maybe it me doing something wrong. (Although I have got to grips
with CF before)

--
Big Rick


"B. R.Ramachandran" wrote:

Hi,

Select B2.
Under "Conditional Formatting",
Formula Is =ISNUMBER(MATCH($B$2,$A$1:$A$11,0))
Format the font color appropriately.

Regards,
B. R. Ramachandran

"Big Rick" wrote:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick

Hi,

Thank you for your feedback.

Regards,
B. R. Ramachandran

"Big Rick" wrote:

I have finally got it to work.
As I was at work and simply tried to type a few figures into a new
worksheet, I made the inexcusable mistake of putting the CF into cell B1!

I consider it an honour to be helped by you.
Your post on the six pointed star was absolutely brilliant. The best I've
ever seen.

<<<<<<
Big Rick


"B. R.Ramachandran" wrote:

Hi,
Yes, I did test the formula before posting my reply.

I tried to mimic conditions where things could go wrong in CF.
Please check the CF formula; if by any chance the formula is enclosed
between double quotation marks, i.e., ="ISNUMBER(MATCH($B$2,$A$1:$A$11,0))",
remove the quotes, and see whether it helps.

If you inadvertently forgot to type the '=' sign when you entered the
formula the first time, Excel encloses the formula between double quotes,
and CF won't work. If you try again, the CF window WILL show an '=' sign at
the front. However, the double quotes will still be there and CF will not
work; and you can make it work by removing those quotes.

Regards,
B. R. Ramachandran


"Big Rick" wrote:

This does not seem to work either.
Have these formulas been tested?
I am eternally grateful for any help given, but if these work on another
computer, maybe it me doing something wrong. (Although I have got to grips
with CF before)

--
Big Rick


"B. R.Ramachandran" wrote:

Hi,

Select B2.
Under "Conditional Formatting",
Formula Is =ISNUMBER(MATCH($B$2,$A$1:$A$11,0))
Format the font color appropriately.

Regards,
B. R. Ramachandran

"Big Rick" wrote:

I have a range of 11 random numbers (but all different) in cells (A1:A11)

In B2 I have a single number.
I would like to Conditionally Format this cell so that if it matches any 1
of the 11 cells it would turn to Green.
Any help would be greatly appreciated.

Thanking you in anticipation.
--
Big Rick