Google Sheets Table Solved

Question

I'm trying to highlight the moment when my professional card will start to expire. Otherwise, a few months before, it should turn red so that I "don't forget" to renew my pro card. I should mention that I'm using Google Sheets.

Cell B1 contains the formula =TODAY(), which reflects today's date.

In theory, once the formulas are correct, rows 1-2-3 should actually be hidden.

The idea here would be to turn cell B5 red when the date falls between B2 and B3. Then, cell B5 should have a red background and white text when the date exceeds date B3.

It's a conditional formatting issue, but I'm unable to apply it. I might not have the right formula or value. Well, I don't see why I can't get it to work.

If a kind soul could share their knowledge with me :)

Thank you in advance for the time you take to read this and possibly help me out ^^

BeeAwolF · Answer

If someone could help me a little...  Thanks in advance :)

PapyLuc51 · Answer

Hello  A proposal  I am correcting the formula entered for B2  =date(YEAR(B5),MONTH(B5)-4,DAY(B5))  Best regards

BeeAwolF · Answer

I think I understand. I say "I think".

Except that I would like the conditional formula to be effective not for a specific date but for a period (between dates).

I hope I am making myself clear :/

Sincerely ^^

PapyLuc51 · Answer

This is what is going to happen - as soon as the color at -4 months becomes visible, it will remain visible until the color at -3 months appears, and the latter will stay visible until the date in B5 is changed.

So it is unnecessary to create a special formula for the duration that separates -4 from -3 months.

It is only necessary for the two conditional formatting modules to be placed in the order I indicated. If they are not when you install them, simply click to the left of the color (three vertical dots) and move it up or down.

Do some tests by changing the date in B5.

Best regards.

BeeAwolF · Answer

Oh, I think I've understood this time. The color "redder" should be on top because it will be "prioritized" over the one below.

I think I've got it.

I'll have to do this with the oil changes, the inspections, the renewals of all kinds ^^

Thanks for the tip :)

PapyLuc51 · Answer

Glad to have helped you.  If that's the case, don't forget to click on "mark as resolved" at the top of the initial message.  Best regards

Google Sheets Table

6 answers

Message saying that my phone is compromised

Very slow computer

Retrieve an email address

Phone alarm plus connected

Select text

No sound on my laptop

Chronology

What does sata mean when it’s displayed on my hp laptop?

Unlock toshiba 32rl933 tv pin code

Microsoft 365