Macro to Format a Row Based on IF Statement

[MSmithson]

Hello all,

Just need a little help writing a macro that will format a row based on an If Greater Than statement.

In each row, if the date in the column marked “Effective Date” (row 1 header) comes after (is greater than) the date in the column marked “Start Date” (row 1 header) in that row, then the entire row font is changed to red and made bold.

Help is most appreciated – thank you!

[protonLeah]

Why a macro?