I
I
Illarion Labahua2018-02-16 22:14:40
Google Sheets
Illarion Labahua, 2018-02-16 22:14:40

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

1 answer(s)
I
Illarion Labahua, 2018-02-16
@Illarion_me

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 question

Ask a Question

731 491 924 answers to any question