Can't find how to do this.
I want to highlight cells with a number of days(obtained by using a formula), in green for a number of days under a certain limit and red for over that limit.
Be grateful for any help.
Hughie
Numbers 3.5.2 (2118), Yosemite
iMac, OS X Mavericks (10.9)
Hi Hughie,
I am not sure what formula you are using to calculate the number of days, but here is an idea.
Body Cells in B and C are formatted as Date & Time with no Time displayed
Format Panel > Cell > Data Format > Date & Time
Formula in D2 (and Fill Down
=C2−B2
If days (for example 8d) do not appear, format column D like this
In Conditional Highlighting, Add a Rule and choose Durations
If you are calculating the days between the start date and today, Column C could have the formula =TODAY
Regards,
Ian.
Hi Hughie,
I am not sure what formula you are using to calculate the number of days, but here is an idea.
Body Cells in B and C are formatted as Date & Time with no Time displayed
Format Panel > Cell > Data Format > Date & Time
Formula in D2 (and Fill Down
=C2−B2
If days (for example 8d) do not appear, format column D like this
In Conditional Highlighting, Add a Rule and choose Durations
If you are calculating the days between the start date and today, Column C could have the formula =TODAY
Regards,
Ian.
Hi Ian
That is fantastic - my spreadsheet is sorted! You've no idea how much simpler you've made my life!
Hughie
Hi Hughie,
Greetings to King's Lynn from Australia. I am glad the highlighting works. Keep posting in Apple Support Communities.
Regards,
Ian.
Highlighting cells.
