Hello all,

I am a beginner with Excel and currently struggling with how to format it to do what I want. Here is the skinny. I have a cell "O7" that calculates a total number. I need formulas that according to that number will change the fill color in a column of cells related to that number. If O7 is 1-5 then J5 through J9 force the fill to be yellow. no other columns should be affected. Then if the number in O7 is >=6 and <=10 it will do the same as before but to column k and so on and so forth. I hope this makes sense and someone can help me with figuring this out. I am pretty close but clearly I have done something wrong because not all the cells change the fill in my selection, just the top on I selected. Any help would be greatly appreciated!