Conditional Formatting Doubt

[santhkrishnan]

Dear Sir,

i am new to this forum. i need to help to how to use conditional formatting against my request.

Please refer the following details related to my doubt.

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
[TD="class: xl65, width: 64"]A[/TD]
[TD="class: xl66, width: 64"]B [/TD]
[TD="class: xl67, width: 64"]C[/TD]

[TD="class: xl68, width: 64"]AA[/TD]
[TD="class: xl69, width: 64"]12000[/TD]
[TD="class: xl70, width: 64"]13000[/TD]

[TD="class: xl68, width: 64"]BB[/TD]
[TD="class: xl69, width: 64"]11000[/TD]
[TD="class: xl70, width: 64"]10000[/TD]

</tbody>

in c Row i need to use conditional formatting by if C Values is greater than B means it has to highlight in Green Color. if C value less than B value it has to highlight in Red Color. like this i need to copy for all rows around 50 rown.

Please guide me how to proceed.

 

[Michael M]

Highlight all the cells in column C
Open conditional formatting>>New Rule>>Use formula>>=C1>B1>>format as required
Repeat for =C1<B1