Bolding a note

I have a column for Notes. How do I set up conditionally formatting so the most recent note is bolded? Each note has a different date.
Answers
-
You could add a checkbox column to the sheet with a formula to check the box if the date on that row is the latest in the column. The formula would be like this, where "date" is the name of your date column.
=IF(date@row = MAX(date:date), 1)
This means if the date in the row is the maximum of all the dates in the column, return 1 (which in a checkbox column will check the box).
You can make this a column formula and hide it so it doesn't bother you.
Then in your conditional formatting, you set the condition that if the column you just made (I called mine Latest Date) is checked, then bold the row (or cell).
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives