Question : google sheets refer to another sheet in conditional formatting
Answered by : charlesalexandre-roy
# Short answer:
# To refer to another sheet in a conditional formatting equation in
# Google Sheets, you need to use the INDIRECT function (see link)
Source : https://support.google.com/docs/thread/4490297/conditional-formatting-based-on-the-values-of-another-sheet?hl=en | Last Update : Sun, 17 Jul 22