Conditional Formatting Rule in Google Sheets

[Shazir]

I am using below formula that is working fine on same sheet to highlight the row where found "Terminated".

=$E3="Terminate"

But when i apply below formula based on the values of another sheet where found "Terminated" then it does not work.

=Leave Data!$E3="Terminate"

I want to highlight the same row for both sheets. Where Leave Data!$E3="Terminate".

Can someone please share a solution to this question.

 

[Joe4]

We used to have to use Named Ranges in order to do that, but it claims that may no longer be necessary.
See: Conditional formatting based on another sheet • AuditExcel.co.za

 

[Fluff]

Try

='Leave Data'!$E3="Terminate"

you need to wrap the sheet name in single quotes if it contains a space.

 

[Shazir]

Using this on google sheet where receiving this error.

Conditional format rule cannot reference a different sheet.

 

[Fluff]

If you are using this in Sheets then
a) you need to mention that as Excel & Sheets have a lot of differences.
b) You need to post it in the General Discussion & Other Applications section of the board.
I have moved it for you this time.

 

[Fluff]

Conditional format rule cannot reference a different sheet.

Judging by this, you cannot do it.

 

[Shazir]

Apologies and thanks for moving it to the right place.

 

[Shazir]

Judging by this, you cannot do it.

Its possible i have found some formulas which solve but its difficult to recreate according to need

 

[Fluff]

As I know nothing about Sheets, I'm afraid I cannot help.

 

[Joe4]

I was obviously answering from an Excel standpoint, before it was determined this is a Google Sheets question.
As I have never used Google Sheets, unfortunately I have nothing to add.