Conditional Formatting (If a>b)

[Hardeep_kanwar]

how can i make the cell red if a:a>b:b by using Conditional formatting



A B
500 550
650 600
700 450
200 220
100 90
780 650
Thanks

hardeep kanwar

 

[Gord Dibben]

Select column A

Format>CF>Formula is: =$A1>$B1


Gord Dibben MS Excel MVP

 

[Hardeep_kanwar]

Thanks Sir

It Works

Thanks Again

Hardeep kanwar