Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2019, 07:54 AM
RocketRon RocketRon is offline Formating Cells Windows 10 Formating Cells Office 2010
Novice
Formating Cells
 
Join Date: Aug 2019
Posts: 3
RocketRon is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-02-2019, 05:58 AM
p45cal's Avatar
p45cal p45cal is offline Formating Cells Windows 10 Formating Cells Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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
Attached Files
File Type: xlsx msofficeforums43326.xlsx (9.6 KB, 11 views)
Reply With Quote
  #3  
Old 09-12-2019, 08:58 AM
RocketRon RocketRon is offline Formating Cells Windows 10 Formating Cells Office 2010
Novice
Formating Cells
 
Join Date: Aug 2019
Posts: 3
RocketRon is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 09-28-2019, 03:20 PM
p45cal's Avatar
p45cal p45cal is offline Formating Cells Windows 10 Formating Cells Office 2016
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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)
Attached Files
File Type: xlsx msofficeforums43326b.xlsx (9.7 KB, 8 views)
Reply With Quote
Reply

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 Formating cells in a Row mbesspiata Excel 6 06-27-2014 08:12 AM
Formating Cells Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft