Formating Cells

RocketRon · #1 08-31-2019, 07:54 AM

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

p45cal · #2 09-02-2019, 05:58 AM

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

RocketRon · #3 09-12-2019, 08:58 AM

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

p45cal · #4 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