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.

 

[Shazir]

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.

Sir, Thank you for you reply.

 

[tusharm]

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.

Well, you can always "cheat."

Suppose you want to conditional format Sheet2!A1 based on the value of Sheet1!A1 (irrespective of gSheets or Excel):

In Sheet2, in some available cell, say B1, enter the formula =Sheet1!A1

Now, format Sheet2!A1 based on the value of Sheet2!B1.

This is a very powerful technique I've used to 1) make complex c.f. formulas transparent and b) implement c.f. conditions that are simply not doable directly within a c.f.

 

[Shazir]

tusharm​

Thank you.