Where do I begin..sorry first post to site. I am trying to use a sum to base all other criteria off of. I have column A (increment), B (hyphen), C (IF function and conditional formatting) on page 1 and the sum on page 2. The end goal is a very basic goal chart in which will fill column C with a color if the criteria is met in regards to the sum on page 2.
the second value is:
=IF(AND(Sheet2!C30>499,Sheet2!C30<750,),"True","")
the problem comes in when the sum increases say to 600 the initial value turns false and then only one value is highlighted instead of them stacking and the base remaining highlighted as well. Boy I sure hope someone can understand what I am trying to accomplish. Thank you.
the base value is: =IF(AND(Sheet2!C30>249,Sheet2!C30<500),"True","") the conditional formatting will highlight the cell red if true. |
=IF(AND(Sheet2!C30>499,Sheet2!C30<750,),"True","")
the problem comes in when the sum increases say to 600 the initial value turns false and then only one value is highlighted instead of them stacking and the base remaining highlighted as well. Boy I sure hope someone can understand what I am trying to accomplish. Thank you.