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
2807
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 21, 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
2807
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 21, 2021
483
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.