[Solved] Conditional Formating

[pauly88]

Hey everyone,

I'm not a spreadsheet person and I'm really struggling with this. I've seen a bunch of instructions but nothing's really helping me get the it to work. I just need cells with a date in for example 15/10/2019 to turn red on that day, can any one give me a formula to enter into the conditional formatting window to make it do that? I've set up a labeled style with background colour so it can change to that style, I just need to figure out how to make it do that on the written day in the cell. If someone could help me with this I'd be really grateful.

Sincerely.

Paul.

[Zizi64]

Use the Today() function in the condition

The Conditional Format function in my LibreOffice 6.1.6:

[pauly88]

Awesome! Thank you! I just tried it out and tested it on todays date and I think it works, thanks!