Formating Cells

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Formating Cells

FAQ

Thread Tools

Display Modes

09-28-2019, 03:20 PM

p45cal

Windows 10 Formating Cells

Office 2016

Expert

Join Date: Apr 2014

Posts: 962

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

msofficeforums43326b.xlsx (9.7 KB, 10 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:44 AM.