Conditional Format Problem.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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:
 
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.
 
Neither of these solutions are working.
Please can you help me further.

Thanking you in anticipation
 
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
 
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)
 
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
 
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
 
Back
Top