Forum Discussion

raquelbuzz's avatar
raquelbuzz
Copper Contributor
Oct 23, 2019

Conditional Formatting one cell based on another

Hi 

 

Please can somebody help me.

I have 2 columns of numbers - sales this week and sales last week.

how can i conditional format so that sales this week are green if > last week, and red if < last week

excel
Formulas and Functions

1 Reply

  • nabilmourad's avatar
    nabilmourad
    MVP
    Oct 23, 2019

    raquelbuzz 

    Hi Rachel

    I created a sample sheet with This week sales in Column A and Last week sales in column B.

    You need to select the numbers in Column A (where the formatting  will appear) and create 2 conditional formatting Rules (Home Tab >> Conditional Formatting >> new Rule >> Use Formulas:

    Rule 1:

    =A2>B2    Format >> Green Fill

    Rule 2:

    =A2<B2   Format >> Red Fill

    Please look at the attached File

    Hope that helps

    Nabil Mourad

Resources