Excel 2007 : Conditional Formatting

[hazza]

Hi guys,

I am wondering if somebody can help me with conditional formatting...?

Basically i want to format/highlight a cell if the value inside falls below the average of three seperate cells.

Specifically, i want to highlight cell F1 if its value falls below the average of cells I1 J1 and K1.

Thanks in advance.

[royUK]

Select the Cell & from Conditional Formatting -> Highlight Cell Rules -> Less Than -> then type

="average($I$1:$K$1)"

Finally set your Format

[hazza]

Thanks very much. Worked a treat.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save