Google Sheets - Conditional Formating - using ISBLANK to reference a cell in a different sheet

0
votes

I'm new to Google Sheets so would appreciate some assistance as my research has been unsucessful.

I have created a schedule with peoples names filling time slots. I have duplicated the sheet for the same layout to be able to create a print out that shows which time slots are available using just colours so as not to distribute the names listed. To do this I want to use conditional formating and show a colour in the cells (time slots) not yet filled.

I thought that the custom formula needs be something like... conditional formating for cell E14 on sheet "Schedule Printout"... ISBLANK('Schedule!E14') but this doesn't work.

Screen grab of the Conditional Formating dialog box

I have tried several different variations. If you have any ideas please can you let me know?

Thank you

James Webb jameswebb.uk

1
google-sheetsgs-conditional-formatting
Possible duplicate of Condition Formating, how to highlight a cell when it dosn't include text in a list – TheMaster
Possible duplicate of Conditional Formatting from another sheet – Max Makhrov

1 Answers

1
votes

See if this works

=INDIRECT("Schedule!E14")=""

I believe you have to use INDIRECT in conditional formatting when you want to reference a different sheet/tab.