Forum Discussion
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 She...
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?