Forum Discussion

Ramin Tameer's avatar
Ramin Tameer
Copper Contributor
Mar 16, 2018

Conditional formatting using formula IF

I need conditional formatting if A1not equal to B1, then C1 to be an orange colour ( column A and B are dates)

any help appreciated

 

excel
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 17, 2018

    Hello Ramin,

     

    Please do the following steps:

    • Select column C entirely so that the cell C1 is the active cell.
    • Go to Home >> Styles >> Conditional Formatting >> New Rule
    • From the New Rule dialog box select Use a formula...
    • In the formula box put this formula: =A1<>B1
    • Click Format button to select the color and then hit OKs.

    Please find the attached file.

     

    Hope that helps

    Haytham

     

Resources