Aug 28 2017
07:55 PM
- last edited on
Jul 25 2018
09:59 AM
by
TechCommunityAP
Aug 28 2017
07:55 PM
- last edited on
Jul 25 2018
09:59 AM
by
TechCommunityAP
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,
Aug 28 2017 09:23 PM
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?