is it possible to select (for conditional formatting) cells who refers to cells in other sheets or documents? how?
example: =$sheet2.$F$16 but also =$sheet7.$G$10
Thank you
thank you, that works
As I know the new conditional format is only per sheet.
But doing a try, seems it is possible to do it, while in the sheet where you want apply the CF selecting in the condition “Formula is” and enter a formula with references to other sheets.
See the attached sample:
Conditional Format referenced to other sheet