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

Copper Contributor

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,

1 Reply

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?