Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-26-2016, 09:59 AM
jeffreybrown jeffreybrown is offline Conditional formatting to color cells based on number Windows Vista Conditional formatting to color cells based on number Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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
Reply With Quote
 

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
Conditional formatting to color cells based on number 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
Conditional formatting to color cells based on number 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 formatting to color cells based on number 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 09:05 AM.


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