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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives