Matching, Cell Coloring, Greater than

  • Thread starter Thread starter cpone
  • Start date Start date
C

cpone

Ok I have been searching on here for about 2 days. Not continuously but
you get the idea, for a function or way of doing this automatically.

I have a lists of numbers in column A
I have another list of numbers in column B

In column C I have SQ feet of a store

here is where things get nasty

In Column D(lets say) I have Percentages as well as a differecnt set
of percentages in column E.

I want to set it up so that
1. Column B highlights all the same numbers in column A (or hide them)
2. Column B also finds from Column D all values greater than or equal
to 70 and makes that lets say green
3. Column B also finds from E all percentages less than 20 and
highlights them green also.

Now I found a formula that helps me with the first part here it is:
=NOT(ISNA(MATCH(C1,A:A,0)))

Do i know what it means? No.. would I like to yes.

Any help would be great.



The others I dont know how to do.
 
You need conditional formatting, with formulae like
=B1=A1
=OR(D1>70,E1<20)

and format to your chosen colours.

The formula just matches the value in C1 in column A, and returns TRUE or
FALSE.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I tried that Bob but it just highlights by line. I need the formula to
understand that store #7 in column A needs to correspond to the same
store number in column C which has 2 sets of percentages it
corresponds to. The stores arent lined up by row.
 
Back
Top