Excel formulas and rules

Navigation
1

I have an excel where I have a column where I keep dates. How can I make the dates red by more than 30 days? I have been testing with SIFECHA and with conditional format but I do not achieve anything thank you very much

The format is a short date, and I am trying this but it fails me: 

=(C4 – $B$1) <= 30

b1 is where I have the date today and c4 where I have the other date

    
asked by francisco 15.03.2018 в 12:00
source

1 answer

2

I have them like this:

  • In conditional format.
  • Condition: =HOY()-30 ;

    
answered by 15.03.2018 / 12:11
source
C chain overflow Vertical scroll by parts