In Calc, how would I go about making a cell change based upon the condition of another cell being met?
For example, if the header of column was the date, and I wanted to check if the date was TODAY(), and if so, then I would want to make a certain row a different colour and have this apply to every single cell in its row.
Thanks.