depends on what you want ... if you have
..........A...............B.............
1......Item..........Update Date
and you want the relevant update date to turn red when it is more than a
year ago ... then
select from B2 to the end of the column of data and then scroll so that row
2 is at the top of the screen (first line you can see)
choose
format / conditional formatting
choose
formula is
type
=$B2<=today()-365
click the format button, set the background colour (under the patterns tab)
to whatever you want (etc)
click OK twice
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
