Excel How to find the current cell address

Question

I have a column on my chart where I place the arrival date of a product. I would like to create a conditional formatting (put the cell in red) when there were 15 days or less for the product to arrive.

The formula I used was =$B$7-HOJE()<=15

The problem is that I need the line, in case "7", to be variable, that is, it must be the number of the line the cell is in. Is it possible to do that? Thanks for your help.

Answer 1

Select the cell where you want to apply the formatting rule and click "Conditional Formatting".

Choose, "Manage Rules".

Make sure there are no other rules that may conflict.

In this example, it’s empty, so we’ll just create a new rule "New Rule..."

Choose "Use formula to determine which Cells to format"

In the "Format values Where this formula is true" field, type the following formula

=B7<=TODAY()-15

_{*Be careful with the keyboard arrow keys as the LEFT and RIGHT keys automatically navigate between cells and insert their respective references in the formula field.}

After adding the formula, click on "Format..."

For this test, we will modify the color of the cell only

After setting the formatting, click OK

On the next screen, click "Apply" and "OK"

When you click on "Apply", the formatting is already applied.

To extend the rule to other cells, just copy and paste.

For cells with existing values, use the "Special Paste" command and choose "Formatting". This will copy only the formatting rule.