#1
|
|||
|
|||
Formating Cells
01/09
02/09 03/09 04/09 05/09 06/09 07/09 08/09 09/09 10/09 11/09 11/09 12/09 13/09 14/09 15/09 16/09 Code:
An Excel sheet with column of short dates 01/09-16/09 as above I want to enter a short Date in a cell and the background change to yellow Say I enter 03/06 then the column cell would change and then with a formula so that every six days would also change to yellow 09/09 and 15/09 |
#2
|
||||
|
||||
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 3rd September 2019 is entered into it.
Conditional format formula is: =MOD(A1,6)=1 |
#3
|
|||
|
|||
Hi
Thanks for your help I fully understand the information in your example and it works as you said The problem came when I tried to have the first date as the start point I did this by adding dates 28 Aug to 15 Sep but for some reason it started after the 4th Day not 5th Day as I required can you help |
#4
|
||||
|
||||
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) |
Thread Tools | |
Display Modes | |
|
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 |