|
|
#1
11-01-2018, 10:43 AM
|
|||
|
|||
Conditional Formatting Individual Rows in a range
In the range of cells, if the POP End date is less than or equal to the value in cell AK40, format background red. Applies to AH2:AK2 in this example.
I need this to apply to the entire range – to highlight (format) the row when the row POP End value is less than or equal to the date value in AK40 In this example, rows 1, 3, and 4 should be red background. What would the CF formula be? See Attachment 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional Formatting - Duplicates - Apply to specified range
|
music_al | Excel Programming | 1 | 01-25-2017 05:34 AM |
| Conditional Formatting a Range | Phil H | Excel | 3 | 02-17-2016 08:33 AM |
| VBA Conditional Formatting Error (Subscript out of Range)) | tinfanide | Excel Programming | 1 | 05-15-2015 08:12 AM |
| Conditional Formatting - color only dates contained in a range | EC37 | Excel | 1 | 07-08-2014 12:51 PM |
| Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |
Windows XP 
Office 2010 64bit
Threaded Mode