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.

A	B	C
AA	12000	13000
BB	11000	10000

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</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