Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-21-2019, 04:07 AM
RocketRon RocketRon is offline Conditional Formatting Windows 10 Conditional Formatting Office 2010
Novice
Conditional Formatting
 
Join Date: Aug 2019
Posts: 3
RocketRon is on a distinguished road
Default Conditional Formatting

Hi
I want to start formatting on the first short date in the column and repeat each 5th day see example * dates marked yellow background

08-Nov*
09-Nov


10-Nov
11-Nov
12-Nov
13-Nov*
14-Nov
15-Nov
16-Nov
17-Nov
18-Nov*
19-Nov
20-Nov
21-Nov
22-Nov
23-Nov*
If I use the following formula the return is partly correct but I cannot get it to start on the nominated date
Code:
 =MOD(B1,5)= 1
Is what I want possible
Reply With Quote
  #2  
Old 11-23-2019, 10:41 AM
BobBridges's Avatar
BobBridges BobBridges is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I'm not sure what you mean; it might help if you use actual sentences in that first line, with occasional punctuation. And what do you mean by "short date"?
Reply With Quote
  #3  
Old 11-25-2019, 08:36 AM
p45cal's Avatar
p45cal p45cal is offline Conditional Formatting Windows 10 Conditional Formatting Office 2019
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

Adjust the solution offered at https://www.msofficeforums.com/145332-post4.html by changing the 6 to a 5.


(Full thread: https://www.msofficeforums.com/excel...ing-cells.html )
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting chrisoconn Excel 0 07-05-2017 02:10 AM
Conditional Formatting Is Conditional Formatting Possible? Wocky Project 1 01-16-2017 05:39 PM
Conditional Formatting Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 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