pobiom
Level 1
(4 points)
iWork
Q: Conditional Formatting
I am looking to create a table using numbers with some conditional formatting included, set around dates. Can anyone show me where I can find out how to auto populate a cell with a certain colour when a date is reached in a different cell?
Many thanks!
Patrick
iMac, OS X Yosemite (10.10.5)
by t quinn,Apple recommended
t quinn
Level 5
(5,012 points)
Mac OS X
Hi Patrick,
Conditional highlighting can only compare the cell to be highlighted another. So you need to create a new column.
My hidden column duplicates the data column when the date in column a is past.
The conditional highlighting kicks in if the two cells are the same.
quinn
