Forum Discussion

CHRISTOPHER GREGORY's avatar
CHRISTOPHER GREGORY
Copper Contributor
Aug 28, 2017

Conditional formating for a value based on that values presence in another sheet

I am trying to formate a cell using conditional formating so that when the value in cell C1 on Sheet 1 is present in column C on sheet 2 the color changes to green, or if the value in cell  C1 on Sheet 1 is present in column C on Sheet 3 the color changes to orange.

 

I am new to conditional formating. I have tried several things from various posts but nothing seems to be quite like what i'm trying to accomplish and therefore has not worked. Any help is appreciated.

 

Thanks,

Formulas & Functions
tips and tricks

1 Reply

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    MVP
    Aug 28, 2017

    Hello,

    create a new conditional format that uses a formula. Put in this formula

     

    =COUNTIF(Sheet2!$C:$C,$C1)

     

    and select green as the format. Then create another format with the formula

     

    =COUNTIF(Sheet3!$C:$C,$C1)

     

    and select orange as the format.

     

    Does that help?