Need some help here, because I don’t know how to do what I want to do.
As always, thanks to everybody that helps out.
I"m using LO 25.2.1.2. I’m trying to set up conditional formatting.
I have an array 4col X 72 rows (A25:D96). Columns A-C are dates. I want to set up conditional formatting such that the entire row (all 4 columns are highlighted) if the value (date) in column B is the latest date less than today.
I have already tried setting up CF as follows: Format/Conditional/Manage/Add, and used the following: Condition 1: Formula is =$B25=TODAY(). But it doesn’t work. First thing that I noticed was that the FIRST equal sign is missing after I click OK. So, I’m wondering - why doesn’t it work?