Conditional formatting based on range ofcells in different sheet
Closed
iveta96
Posts
1
Registration date
Saturday May 30, 2015
Status
Member
Last seen
May 30, 2015
-
May 30, 2015 at 12:23 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 1, 2015 at 11:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 1, 2015 at 11:49 AM
Related:
- Conditional formatting based on range ofcells in different sheet
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Mark sheet in excel - Guide
- Cmd network commands cheat sheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 1, 2015 at 11:49 AM
Jun 1, 2015 at 11:49 AM
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.
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.
