How to get a link to the current cell in Google Sheets?

Question

Google

Hello. There is such a table. What I need:
- So that the cells in the range A2:A4 (titles of articles) change color depending on what RAZDAT() returns.
RAZDAT, as you can understand, I return the "age" of the articles - that is, (the current date-date of the original). And depending on what it returns, different colors are needed.
You can, of course, write for each individual line - but this is wildly steamy, because there will be many lines. So I would like to know how to get a link to the current cell? I need this for a conditional formatting formula that I want to write something like this (but I shoveled through a bunch of Google pages and didn’t find anything useful):
=IF(RAZDAT(+1_to the right_of_the_current_cell;
That is, for A2-A4 to automatically look for the difference not between the current date and some fixed cell, but the current date and the cell to the right of each cell with the name of the articles. Well, so that you can throw formatting on the range A2: A4, and not format one line at a time, and then A2 will calculate the difference between C2 and B2, A3 - between C2 and B3, etc.
I hope I wrote clearly - I've just been sitting for 4 hours :(

Answer 1

Jan, good afternoon!
If I understood the question correctly, here is the solution:
https://docs.google.com/spreadsheets/d/15FVifWhOSh...
I formed the conditions around the value of 10 days (i.e. the age of the articles (C2-B2) is less , greater than and equal to 10 days)
Since you need to paint over the cells of column A, you need to create conditional formatting for the initial cell (in this case, A2