Macros in a cell function
Hi RedDragon,
The problem you've described accounts for only one condition, so Conditional
Formatting is a candidate.
Rob's formula (for cell B2) uses the MATCH function to test whether the
value in the cell being tested is found in the test range (A2:A7), whilst
the 0 in the function specifies that an exact match is required. When the
MATCH function gets a 'hit' it returns the offset to the first match and,
the 0 causes it to return 'N/A' if there is no match. The ISNUMBER function
then tests the MATCH function's results for the presence of any number, and
returns 'TRUE' if MATCH has returned a number. Inserted into a Conditional
Formatting formula dialogue box, the 'TRUE' result then drives the
formatting.
If you place Rob's formula in cell C2, instead of using it as a conditional
formatting formula, and copy it down, you'll get an idea of what it's doing.
Cheers
"Redragon" wrote in message
...
Well, I want to compare 6 numbers against another 6 numbers which are set.
So
I want the first number to check against all 6 of the set numbers and then
the second number to check all the set numbers and so on, and if they
match I
want the number to highlight in yellow. So if we say: -
Set Chosen
3 6 This 6 is in the 'Set' Number
list
6 10
12 14
13 17 This 17 is in the 'Set' number
list
17 20
21 27
So basically I want the 6 and 17 in the 'Chosen' list to be highlighted in
yellow.
Are you with me? And any ideas if so?
Thanks
|