Answer the question
In order to leave comments, you need to log in
How to set conditional formatting based on a cell that is 3 rows above and two columns to the right?
I mean, in the first cell the price of the goods from the store is written, in the second cell - the date the price was updated.
It is necessary that when the price update date is three (for example) days less than the current date, the cell with the price is painted in a different color.
This formula, in my opinion, should be a formatting condition. But she doesn't think so.
The whole problem is that this part of the formula: "INDIRECT(ADDRESS(ROW()+3;COLUMN()+2;4;FALSE);FALSE)" does not take the value from the desired cell.
=IF(TODAY()-INDIRECT(ADDRESS(ROW()+3;COLUMN()+2;4;FALSE);FALSE)>3;TRUE();FALSE())
Answer the question
In order to leave comments, you need to log in
Solution found. use)
=IF(TODAY()-INDIRECT(ADDRESS(ROW();COLUMN()+10;4;TRUE);TRUE)>3;TRUE();FALSE())
The problem was that INDIRECT understands what "O3" but does not understand links in the format "R[3]C[25]"
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question