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

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

appreciatethehelp
432 ●164 ●212 ●239

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

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20317 ●18 ●59 ●59 http://etmg.altervista...

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

add a comment

2

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

JohnSUN

12082 ●10 ●54 ●129

Maybe it will help you

edit flag offensive delete link

Comments

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 ( 2017-10-18 17:35:09 +0100 )edit

add a comment

2

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

robleyd

4140 ●3 ●12 ●33

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

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

add a comment

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

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

Comments

Question Tools

Stats

Related questions

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

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

Comments

Question Tools

Stats

Related questions

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

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