Excel How to find the address of the current cell

5

I have a column in my table where I place the date of arrival of a product. I would like to create a conditional formatting (put the cell in red) when it is 15 days or less before the product arrives.

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 where the cell is. Is it possible to do that? Thanks for the help.

    
asked by anonymous 10.10.2014 / 14:52

1 answer

3

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

Choose, "Manage Rules".

  

Makesuretherearenootherrulesthatmightconflict.

Inthisexample,itisempty,sowewillonlycreateanewrule"New Rule ..."

  

Choosethe"Use a formula to determine which cells to format" option

  

Inthe"Format values where this formula is true" field, type the following formula

=B7<=TODAY()-15

* Be careful with the keyboard's directional keys as the LEFT and RIGHT keys automatically navigate between cells and enter their respective references in the formula field.

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

  

Forthistest,let'schangethecolorofthecellonly

  

Aftersettingtheformatting,clickOK

  

Onthenextscreen,click"Apply" and "OK"

  

Themomentyouclick"Apply", the formatting is already applied.

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

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

  

    
16.02.2017 / 20:22