Forum Discussion

Teeah's avatar
Teeah
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 to Column A

3. If Column A is larger than Column B, highlight the entire row (or enter "Update" in Column C)

Please see workbook attached.

 

*Don't need anything done if Column B is larger than Column A so not checking for that but just for learning purposes if I wanted to have Excel check if Column B is greater than Column A and if it is then enter "All Good" in Column C, how would I do that too?*

 

Thanks!!

excel
Formulas and Functions
Macros and VBA
office 365
training

3 Replies

    • Teeah's avatar
      Teeah
      Copper Contributor
      May 04, 2020
      Thanks Sergei.
      Please explain what exactly you're telling Excel to do here...
      • SergeiBaklan's avatar
        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).

Resources