Excel 2010 Conditional Format with multiple conditions
Posted on 2011-02-23
I have a spreadsheet that I would like to conditionally format a row based on several criteria. I'm going to do my best to provide an example to help relay what I need.
Let's say I have 3 columns
DIVISION, AGE, WEIGHT
I want to highlight the rows with the following sets of criteria
Yellow Highlight if...
AGE & WEIGHT (here is where I get lost...)
If (AGE=8 AND WEIGHT =>90) OR (AGE=9 AND WEIGHT =>75)
THEN Highlight the row Yellow
Okay not too bad, now I totally lost myself in this next request...
Red Highlight if...
AGE & WEIGHT
IF (AGE=8 AND WEIGHT <=85 AND WEIGHT <=89) OR (AGE=9 AND WEIGHT <=70 AND WEIGHT <=74)
THEN Highlight row Red
Hope this makes sense.
Thank you in advance,