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)
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
Thats great, thanks for getting back to me, it is appreciated 🙂
Conditional Formatting
