Forum Discussion

Copper Contributor

Jan 29, 2020

Solved

Problem with date conditional formatting

Hello everyone, im having trouble conditional formatting some dates in excel, as you can see in the screenshots, I inserted a IF function to check if the formula (between 30 and 15 days ago) is actually true, also the next one doesnt seem to work (less than 15 days ago).

Today is 29/01/2020.

Thanks to everyone for your help.

Formulas and Functions

SergeiBaklan
Jan 29, 2020
Marco97

I only corrected couple of misprints

Please check in attached file
conditional formatting problem.xlsx18 KB

8 Replies

Sabry10
Brass Contributor
Jan 29, 2020
=SUMIF(P7:Z7">="G11";P9:Z9)...sir i tried but not working
Sabry10
Brass Contributor
Jan 29, 2020
=SUMIF(P7:Z7;>=G11;P9:Z9) what is wrong here plz need to know
- SergeiBaklan
  Diamond Contributor
  Jan 29, 2020
  Sabry10
  
  That's answered here https://techcommunity.microsoft.com/t5/resources-and-community/modern-excel-webinars/m-p/1136794/highlight/false#M591
SergeiBaklan
Diamond Contributor
Jan 29, 2020
Marco97

Much better if you attach sample file instead of screenshot.

In your rules not formulas, just texts, e.g

(here AND is not closed)
- Marco97
  Copper Contributor
  Jan 29, 2020
  Here’s the sample file
  conditional formatting problem.xlsx10 KB
  - SergeiBaklan
    Diamond Contributor
    Jan 29, 2020
    Marco97
    
    I only corrected couple of misprints
    
    Please check in attached file
    conditional formatting problem.xlsx18 KB

Resources