Conditional formatting

**stevedickin** · 10-30-2009, 02:39 PM

Hi,

I'm trying to highlight data that exceed a value, but the value will change depending on the value of another parameter. for example

Trying to highlgiht 'fluoride' values that exceed 10 (when 'hardness' value is <10) and exceed 20 (when 'hardness' value is >10)

I don't know the best way to do this. and I don't know how to use macros...

Help would be greatly appreciated. Thanks!

**zbor** · 10-30-2009, 02:42 PM

Something like this:

=AND($B1>20,$C1>10)
=AND($B1>10,$C1<10)

But you didn't define what with other solutions. You have 6 options (and to define what for =):

B<10, C<10
B<10, C>10, C<20
B<10, C>20
B>10, C<10
B>10, C>10, C<20
B>10, C>20

**modytrane** · 10-30-2009, 02:47 PM

see the attached.
you didn't define "if the value equals 20".
modytrane

**stevedickin** · 10-30-2009, 03:17 PM

sorry guys, i didn't quite understand... I think it's how I explained it.
I will try again and explain using numbers.

I'm trying to do an exceedence table for groundwater quality. So the numbers from the wells are concentrations.

These concentrations are compared against government "standards" for acceptable levels of these concentrations.

Some standards, such as fluoride, vary depending on other groundwater parameters (such as the hardness of the water)

So, I'm trying to figure out a way to get excel to automatically highlight the values that exceed the standard without going through the data...

Below is the table I'm dealing with. (I have also attached it.) If anyone could do whatever needs to be done to make it work, and post it back that would be great!

Parameter standard Well 1 Well 2 Well 3 Well 4Hardness N/A 77.2 40 76.2 50
Fluoride 2 (if hardness value < 50) 4 2.2 1.14 3
3 (if hardness value ≥ 50)

if the 'well' values exceed the standard (not less than or equal to) then the well values need to be highlighted.