|
|
|
|
#1
09-28-2019, 03:20 PM
|
||||
|
||||
In the attached, the range A1:E30 has been conditionally formatted to turn yellow when a date which is a multiple of 6 days away from the date in row 1 of each column is entered into it.
The conditional format formula is: =AND(MOD(A1-A$1+1,6)=1,COUNTBLANK(A1)=0) 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
| Formating Partial cells in a large list | Zajac | Excel | 3 | 08-16-2016 09:13 AM |
| Chart Formating with ChartTitle Font and DataLabel Formating | shilabrow | Excel Programming | 0 | 06-30-2014 10:01 AM |
 Formating cells in a Row
|
mbesspiata | Excel | 6 | 06-27-2014 08:12 AM |
|
Excel 07 formating 17 cells "Need Formula"
|
Raner | Excel | 2 | 05-30-2010 02:07 PM |
Windows 10 
Office 2016
Hybrid Mode