Conditional Highlighting In Numbers

Question

Level 1

8 points

Conditional Highlighting In Numbers

In numbers what is the process for conditional highlighting if say i wanted 7 days before a due date for that cell to change colour and stay that colour till that due date. Then After that due date change another colour and stay that way till it has been changed.

eg. Due date 14/7/20. Todays date 7/7/20. The cell would change green today then stay green till the 14. After the 14th would change say red. Then stay red till that due date is changed.

Thanks.

MacBook Pro 13″, macOS 10.15

Posted on Jul 6, 2020 5:10 PM

Reply

Answer 1

Top-ranking reply

Barry

Level 9

59,951 points

Jul 6, 2020 6:33 PM in response to paul_86

Hi Paul,

This is a very similar question to on I answered about a week ago. Here's a repeat of that answer.

Steps to reproduce:

Select the cells to be highlighted (all non header cells in column E).
Click the format brush to open the format inspector, then choose the Cell section.
(optional) Set the fill colour to the colour you want in these cells when the date is more than seven days ahead. (The default setting is 'No Fill", and can be left alone, if desired.)
Click the Conditional Highlighting button at the bottom of the inspector pane
Construct the two CH rules shown.
Click Done.

Note that the rules are listed with the last to become true at the top of the list. Numbers evaluates the rules fromtop to bottom, and stops at the first one whose condition is met.

The cell beside Today: contains today's date. It' there only to tell later readers of this post the date on which the screenshot was taken, and plays no part in the appliction of the CH rules.

Regards,

Barry

Reply

Answer 2

paul_86 Author

Level 1

8 points

Jul 6, 2020 8:30 PM in response to Barry

Hi Barry, I was still not able to get to work how I want.

Above is a screen snippet from the spreadsheet.

For cell F5 and down (H5, J5 also). I want that cell to change say green 14 days before the renewal date and stay green till that day. Then after that day go red until the it is met.

The last visit column changes the renewal due column when edited.

Thanks for the help before.

Reply

Answer 3

Barry

Level 9

59,951 points

Jul 7, 2020 12:46 AM in response to paul_86

Hi Patrick,

The three columns (F, H and J are all showing what they should be if the rule you described in in effect. None of the three renewal dates are within 14 days after 'TODAY'

Enter July 21, 2020 in one of the cells below F5 to test for green fill.

Enter yesterday's date in another to test for red fill.

Regards,

Barry

Reply

Conditional Highlighting In Numbers

Similar questions