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).