Help with Conditional Formatting

[Adamitus]

Hi,

I have a table where the top row shows (day 1, day 2, day3...) and the first column shows (population 1, population 2...) and there are different temperature values inside the table corresponding each to a certain day and population. What I'm trying to do is to get depending if the maximum value is in that population row and day column, to get only the day and population cell highlighted.

Much appreciated!

[Moo the Dog]

See the attached spreadsheet... would it work for you?

Row 1 is conditionally formatted with this formula:

Please Login or Register  to view this content.

Column A is conditionally formatted with this formula:

Please Login or Register  to view this content.

The array is conditionally formatted with this formula (which you can remove if you don't want):

Please Login or Register  to view this content.

Change the ranges as needed and you should be good to go.

- Vince

[Adamitus]

Thanks for all the help!

[Moo the Dog]

You're welcome.

[DataDealer_007]

You're welcome.

Hi, new to the forum. I have a similar condition with the one you helped
the other guy with. However i am not understanding why it worked. I want
to move data conditionally from one worksheet to another for all values that are the same.

So when Cell B1:B200 may contain category type values of Invent or Mounted or Glow move to a new spreadsheet and cell with appropriate Tag -- Invent, Mounted or Glow. If and only if B3 = INVENT OR MOUNTED OR GLOW. Trying to group the categories.

Does that make sense ? I used =IMPP!B3 works fine as long as I eyeball each category. I kinda want the spreadsheet to do that. I need the conditional IF statement in there to loop thru the data like an array and pull it out and group together by category type.

Any suggestions ? thanks DD_007