Timeline for Relative copy conditional formatting that references other worksheet
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 8, 2014 at 22:17 | vote | accept | Seanonymous | ||
| Dec 2, 2014 at 0:38 | comment | added | Seanonymous | And if you only need the formatting to be applied if the cells are not empty: =AND(IF(INDIRECT("R"&ROW()&"C"&COLUMN(),FALSE)=INDIRECT("Default!R"&ROW()&"C"&COLUMN(),FALSE),TRUE,FALSE),NOT(ISBLANK(INDIRECT("R"&ROW()&"C"&COLUMN(),FALSE)))) | |
| Dec 2, 2014 at 0:23 | history | answered | Seanonymous | CC BY-SA 3.0 |