Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting w/ a sumif
I have a sumif formula counting a rolling 6 month period that is summing
total points only accumulated in that 6 months. I'd like to add conditional formatting that will only change the color if that particular instance of earning points is being counted in the sumif formula. I also wanted it to change different colors based on if the particular instance pushed the total points to equal to or greater than 4, 6 and 8. So I'm trying to add the conditions to column C (which is dates of a particular instance) based on whether or not that date is counted in the total Points in column B (where the sumif formula is located). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting w/ a sumif
I believe you have a formula like the one below
=sumif(SOME CONDITION) you probably want a diffferent color depending on the results of the summing like this =if(sumif(SOME CONDITION) 7,TRUE,FALSE) add the if statement to a conditoinal formating cell. "hmsawyer" wrote: I have a sumif formula counting a rolling 6 month period that is summing total points only accumulated in that 6 months. I'd like to add conditional formatting that will only change the color if that particular instance of earning points is being counted in the sumif formula. I also wanted it to change different colors based on if the particular instance pushed the total points to equal to or greater than 4, 6 and 8. So I'm trying to add the conditions to column C (which is dates of a particular instance) based on whether or not that date is counted in the total Points in column B (where the sumif formula is located). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF + Conditional Formatting | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |