Conditional formatting based on range ofcells in different sheet
Closed
iveta96
Posts
1
Registration date
Saturday 30 May 2015
Status
Member
Last seen
30 May 2015
-
30 May 2015 à 12:23
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Jun 2015 à 11:49
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Jun 2015 à 11:49
Related:
- Conditional formatting based on range ofcells in different sheet
- Excel conditional formatting based on date - Guide
- Excel clear formatting - Guide
- Little alchemy cheat sheet - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- How to change account based in instagram - Instagram Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
1 Jun 2015 à 11:49
1 Jun 2015 à 11:49
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.
