Excel highlight row based on criteria
Posted on 2014-10-14
I am wondering if it is possible to highlight /bold a row based on a users input and if so how could i accomplish this.
Essentially, i have a spreadsheet where i enter the year end date (ex; March 31, 2014) in a cell. I then have rows that have are arranged in ascending order based on year (ex row 10 = 2012 row 11= 2013 row 12 = 2014). If the year end date cell is March 31, 2014 i want the 2014 row to be highlighted / bold.
thanks in advanced