Ask Your Question

Calc: Multiple rowed conditional formatting

asked 2016-10-27 05:48:38 +0200

jjww gravatar image

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.


edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted

answered 2016-11-05 18:30:19 +0200

adam1969in gravatar image

If you have the Date in A1, then the formula in Conditional Format would be like this


Select the row you want to format, and then go to conditional format to enter the above formula.

edit flag offensive delete link more

answered 2016-10-27 06:40:19 +0200

karolus gravatar image

Your Example makes no sense for me… header of column in context to CF for whole row ?? Where is the Date to compare with TODAY()?

edit flag offensive delete link more

answered 2016-10-27 07:57:53 +0200

JohnSUN gravatar image

I think you mean something like this - Multiple rowed conditional formatting.ods

edit flag offensive delete link more

answered 2016-11-05 19:04:54 +0200

1·Select the row 2·Deselect the header 3·Format -> Conditionnal Format -> Condition 4·"The formula is" — $A$1=AUJOURDHUI() 5·Apply the style … 6·OK

Should be good.

edit flag offensive delete link more


The formula is :


Like adam1969in said.

FirePowi gravatar imageFirePowi ( 2016-11-05 19:05:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-27 05:48:38 +0200

Seen: 462 times

Last updated: Nov 05 '16