Posts2921Registration dateSunday September 12, 2010StatusModeratorLast seenJanuary 16, 2023549 Jul 1, 2014 at 10:56 AM
Guess what: I just switched to Excel 2013!
You can either pre-select the range you want to apply conditional format to before applying, or you can click on the conditional format button and go to bottom option (Manage rules).
Here you can see the range the conditional format is applied to.
To further assist you I made a screen capture (working with a Dutch version) of the "Manage Rules" screen where you can see that the CF is activated if "Completed" is found in column A and it is applied to the first 20 rows.