Change Colour of Excel Cell with Formula

Rational · 20th July 2006, 6:45 PM

Im using this simple formula to see if a given score is above or below the average score:

Quote:

=IF(L4 > $O$5, "Above", "Below")

Where:

L4 - the score I want to compare to the average
O5 ($0$5) - the cell which contains the average

I would like to change the colour of the cell depending if it is above or below average. Like change the colour to green if it is above average of red if it is below to make it easy for others to see the data.

Regards
Wayne

Seraphic · 20th July 2006, 7:21 PM

You should be able to do it with conditional formatting, using two cell conditions for higher and lower.

Rational · 20th July 2006, 7:33 PM

that worked great, never head of or used conditional formatting before.

Thanks
Wayne

20th July 2006, 7:21 PM	#2
Seraphic Member Join Date: Aug 2003 Location: Adelaide Posts: 43	You should be able to do it with conditional formatting, using two cell conditions for higher and lower.

20th July 2006, 7:33 PM	#3
Rational Member Join Date: Apr 2005 Posts: 4,489	that worked great, never head of or used conditional formatting before. Thanks Wayne