Conditional Formatting

[Spikenaylor]

Hi there

Can anyone help to start me off in the right direction

I need conditional formatting to be active for the Damaged Column but checking the name column,Age and Damaged Column

ie.
If Damaged column value is 5% or more then colour cell red
OR
If Damaged column value is <5% then colour cell Green
OR
If Name column value = Line22 AND Age is <20 then colour cell Orange
OR
If Name Column value = Babcock AND Age is <20 AND Age is <20 then colour cell Blue
OR
If name coloumn value = Babcock AND Age is >35 then colour cell Purple

I just cant figure out how to code the conditional formatting to do all this for the entire column, can do it for a row, but as I have 1200 rows!!

Any help greatly appreciated
Mike

Name	Age	Damaged	Format Colour
Line22	20	3%	Green all OK
Line22	19	3%	Orange due to 19 age
Line22	20	5%	Red due to 5% limit
Babcock	20	3%	Green all OK
Babcock	19	3%	Blue due to 19 lower age limit
babcock	40	3%	Purple due to 40 Upper age Limit
Line22	20	1%	Green all OK
Babcock	30	5%	Red due to 5% limit

<tbody>
</tbody>

 

[etaf]

what version of excel
and you want the whole row to change colour

now because of
If Damaged column value is <5% then colour cell Green
most of those row would be green

so how does the name and age over ride those % value rules

babcock

40

3%

Purple due to 40 Upper age Limit

<tbody>
</tbody>

BUT the value is less than 5% - so green

you need to have the rules unique or which ones take a priority