Conditional formatting based on range ofcells in different sheet [Closed]

Report
Posts
1
Registration date
Saturday May 30, 2015
Status
Member
Last seen
May 30, 2015
-
Posts
2691
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 14, 2021
-
Hi,

I'm trying to make the conditional formatting based on as follows:

cell in sheet 2 is getting red if anywhere in sheets 1,2 and 3 could be find the number 6.1.1

Thank you so much!!!

1 reply

Posts
2691
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 14, 2021
454
Hi Iveta,

Try the following as a conditional format formula:
=(SUMIF(Sheet1!1:1048576,"6.1.1")+SUMIF(Sheet2!1:1048576,"6.1.1")+SUMIF(Sheet3!1:1048576,"6.1.1"))>0

Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!