Thread
:
Formating Cells
View Single Post
09-02-2019, 05:58 AM
p45cal
Windows 10
Office 2016
Expert
Join Date: Apr 2014
Posts: 871
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
msofficeforums43326.xlsx
(9.6 KB, 11 views)
p45cal
View Public Profile
Find all posts by p45cal