Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep conditional format when "show pages" from Pivot table | Excel Discussion (Misc queries) | |||
How do I do a conditional format for numbers | Excel Worksheet Functions | |||
Conditional format problem | Excel Discussion (Misc queries) | |||
Conditional Format Titles | Excel Discussion (Misc queries) | |||
Conditional Format With SUMIF | Excel Worksheet Functions |