We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Conditional formatting: change cell background colour when another cell's date = today [closed]

asked 2017-10-16 08:47:28 +0200

appreciatethehelp gravatar image

updated 2020-09-23 13:32:11 +0200

Alex Kemp gravatar image

Hi all.

In the example provided I want to change the background colour of cells in the "GOAL" column (columns B through J) as well as cells in the DATE column (column A) to red when the date = today… how might I go about doing this…?

C:\fakepath\Date conditional formatting example.ods

Thanks very much.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-10-17 09:39:00.079839

2 Answers

Sort by » oldest newest most voted

answered 2017-10-16 10:27:16 +0200

JohnSUN gravatar image

Maybe it will help you CF_one_cell_condition_for_entire_row.gif

edit flag offensive delete link more


Just adding that having one cell (e.g. K1) with =TODAY() and comparing against that cell in each conditional format (with $A2=$K$1 in this example) may be more convenient as it makes it possible to enter any other date (or formula with a date result) in K1 to evaluate.

erAck gravatar imageerAck ( 2017-10-18 17:35:09 +0200 )edit

answered 2017-10-16 09:03:02 +0200

robleyd gravatar image

updated 2017-10-16 09:03:59 +0200

Set up a cell somewhere which has the formula =TODAY()

Set your condition as Cell value is equal to the cell you edited above. Add the style you need - you may have to create that. Done.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-10-16 08:47:28 +0200

Seen: 1,399 times

Last updated: Oct 17 '17