Conditional formtting

[vij]

Hi,

Could some one help me with a conditional formatting for the undermentioned condition:

I have data as under in two columns

[TABLE="width: 500"]
<tbody>[TR]
[TD]Individual Average[/TD]
[TD]Team Average[/TD]
[/TR]
[TR]
[TD]00:03:55[/TD]
[TD]00:02:00[/TD]
[/TR]
[TR]
[TD]00:03:55[/TD]
[TD]00:05:00[/TD]
[/TR]
</tbody>[/TABLE]

What I am aiming to achieve is as under
1. If the individual Average is less than Team Average the cell should be filled with Green
2. In case individual average is more than the Team Average the cell should be filled Red

The data is formatted as HH:MM:SS

Using Excel 2010 with Windows &
Thanks.
Vij

 

[T. Valko]

Hi,

Could some one help me with a conditional formatting for the undermentioned condition:

I have data as under in two columns

[TABLE="width: 500"]
<TBODY>[TR]
[TD]Individual Average
[/TD]
[TD]Team Average
[/TD]
[/TR]
[TR]
[TD]00:03:55
[/TD]
[TD]00:02:00
[/TD]
[/TR]
[TR]
[TD]00:03:55
[/TD]
[TD]00:05:00
[/TD]
[/TR]
</TBODY>[/TABLE]

What I am aiming to achieve is as under
1. If the individual Average is less than Team Average the cell should be filled with Green
2. In case individual average is more than the Team Average the cell should be filled Red

The data is formatted as HH:MM:SS

Using Excel 2010 with Windows &
Thanks.
Vij

Try this...

Let's assume the range to format is A2:A10.

Select the *entire* range A2:A10 starting from cell A2.
Cell A2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab-Styles-Conditional Formatting-Manage rules-
New rule-Use a formula to determine which cells to format

Enter this formula in the box below:

=AND(COUNT(A2:B2)=2,A2 < B2)

Click the Format button
Select the Fill tab
Select a shade of Green
OK
OK
New rule-Use a formula to determine which cells to format
Enter this formula in the box below:

=AND(COUNT(A2:B2)=2,A2>B2)

Click the Format button
Select the Fill tab
Select a shade of Red
OK out

 

[vij]

Thanks Valko. It works just fine.

 

[T. Valko]

Thanks Valko. It works just fine.

You're welcome. Thanks for the feedback!