Conditional formatting to color cells based on number

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting to color cells based on number

FAQ

Thread Tools

Display Modes

12-26-2016, 09:59 AM

jeffreybrown jeffreybrown is offline

Windows Vista Conditional formatting to color cells based on number

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Here is one way...(and there are surely others)

Beginning in A371 and down, put in the actual date (i.e., 1/1/16, 2/1/16, 3/1/16 etc)

Then in B371 copied down

=SUMPRODUCT(--(MONTH($A$3:$A$368)=MONTH(A371)),$B$3:$B$368)/SUMPRODUCT(--(MONTH($A$3:$A$368)=MONTH(A371)))

In A371, place a custom format to get January, February etc

Custom Format

Right click cell (or Ctrl + 1)
Format Cells
Number
Custom
Type: mmmm

« 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
Sum cell by color that are conditional formatting	ijewel	Excel	1	03-16-2016 05:15 AM
Conditional Formatting based on Value of Another Cell	SteveBump	Excel	3	03-07-2014 09:16 AM
How can I count cells based on their fill color that was set by conditional format	trueimage	Excel Programming	1	10-25-2013 12:08 PM
Conditional color fill based on presence of data	avanderh	Excel	11	07-28-2011 09:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 AM.