Conditional Formatting

[RSTS01]

If Column A is showing "backload" what formatting would I use to highlight Column B where there is a positive value?


[TABLE="width: 96"]
<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="class: xl67, width: 64, bgcolor: transparent"]Manifest[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent, align: right"]5.25[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Backload[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]-5.25[/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, with the "Use a formula" method - you could try, for example:

=AND(A2="Backload",B2>0)

 

[RSTS01]

Worked perfectly

Thank You!