Google Sheets Table
Solved
BeeAwolF
Posted messages
5
Status
Membre
-
PapyLuc51 Posted messages 4566 Registration date Status Membre Last intervention -
PapyLuc51 Posted messages 4566 Registration date Status Membre Last intervention -
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 ^^
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 ^^
