Forum Discussion

Copper Contributor

May 02, 2020

Help Please!

Two Columns A and B. Column A is (99%) populated, Column B may/not be. I want Excel to: 1. Check if Column B is empty If it is, leave it, do nothing 2. If Column B is not empty, compare it...

Sample Workbook.xlsx11 KB

excel

Formulas and Functions

Diamond Contributor

May 02, 2020

Teeah

You may apply conditional formatting rule as

Sample Workbook.xlsx19 KB

Teeah

Copper Contributor

May 04, 2020

Thanks Sergei.
Please explain what exactly you're telling Excel to do here...

SergeiBaklan
Diamond Contributor
May 04, 2020
Teeah

We select entire table, on ribbon Home->Conditional Formatting->New rule->Using formula...

Here enter the formula as above which says that format is triggered if for the current row (we use relative references for rows) value in column D id more than value in column E AND value in E is not blank (we use absolute references for columns).