Answer the question
In order to leave comments, you need to log in
Is there a variable in Google Sheets that is equal to the cell number?
Good day, colleagues.
Tell me, what are the ways to solve the problem, so that when creating conditional formatting for cell "A", check cell "B" in the same line for the contents of "1" or "2"?
My formula looks like this:
For green - =IF(U1 = 1;true)
, for red =IF(U1 = 0;true)
But for 500 lines it takes a long time to write, is there a variable that determines the line number of the cell being checked?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question