Bolding a note

Jenn123

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.

KPH

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).