ExcelBanter - Conditional Formatting (If ab)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Formatting (If ab) (https://www.excelbanter.com/excel-worksheet-functions/208821-conditional-formatting-if-b.html)

Hardeep_kanwar[_2_]

Conditional Formatting (If ab)

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

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

hardeep kanwar

Gord Dibben

Conditional Formatting (If ab)

Select column A

FormatCFFormula is: =$A1$B1

Gord Dibben MS Excel MVP

On Mon, 3 Nov 2008 08:58:00 -0800, Hardeep_kanwar
wrote:

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

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

hardeep kanwar

Hardeep_kanwar[_2_]

Conditional Formatting (If ab)

Thanks Sir

It Works

Thanks Again

Hardeep kanwar

"Gord Dibben" wrote:

Select column A

FormatCFFormula is: =$A1$B1

Gord Dibben MS Excel MVP

On Mon, 3 Nov 2008 08:58:00 -0800, Hardeep_kanwar
wrote:

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

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

hardeep kanwar

All times are GMT +1. The time now is 09:01 AM.