Help with conditional formatting

[Mchgh9]

[TABLE="width: 547"]
<TBODY>[TR]
[TD]Benchmark</SPAN>[/TD]
[TD] [/TD]
[TD]Average</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Variance</SPAN>[/TD]
[TD]Cumulative Variance from Benchmark</SPAN>[/TD]
[/TR]
[TR]
[TD]£568.00</SPAN>[/TD]
[TD] [/TD]
[TD="align: right"]£569.00</SPAN>[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]+0%[/TD]
[TD]OVER[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=6></COLGROUP>[/TABLE]


Hi

I have conditional formatting on Cumulative Variance so that if it says OVER then the cell is RED. If it says UNDER then the cell is green.

I also want to colour the Variance cell based on the same criteria for the Cumulative cell, but to use the OVER/UNDER text to decide on the colour.

Any ideas?

Thanks for helping,

Dave

 

[theBardd]

Select both cells and use a formula of

=$D2="OVER"

etc.

 

[T. Valko]

[TABLE="width: 547"]
<TBODY>[TR]
[TD]Benchmark</SPAN>
[/TD]
[TD][/TD]
[TD]Average</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Variance</SPAN>
[/TD]
[TD]Cumulative Variance from Benchmark</SPAN>
[/TD]
[/TR]
[TR]
[TD]£568.00</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]£569.00</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD]+0%
[/TD]
[TD]OVER
[/TD]
[/TR]
</TBODY>[/TABLE]


Hi

I have conditional formatting on Cumulative Variance so that if it says OVER then the cell is RED. If it says UNDER then the cell is green.

I also want to colour the Variance cell based on the same criteria for the Cumulative cell, but to use the OVER/UNDER text to decide on the colour.

Any ideas?

Thanks for helping,

Dave

Can't you just use the same formatting rule on the variance column as you did on cumulative column?

 

[Andrew Poulsom]

If your sample data is in the range A1:D2, select C2:D2 and use the conditional formatting formulas:

=$D2="OVER"
=$D2="UNDER"

The $ sign fixes the column reference.

 

[Mchgh9]

THanks for your help.