The following formula should work: =IF(E45<=50, 44.55, IF(AND(E45>50, E45<100), 42, IF(E45>=200, 39.6, «»))) Please note that if none of the conditions are met, the Excel formula will return «» as the result. For example, the formula COUNT(B5:C14) in cell C2 displays 9 because nine cells (the cells in C5:C13) in the range B5:C14 contain numbers. (See Figure 2.) How do I count the number of blank cells in a range? Join the Stack Overflow Community Stack Overflow is a community of 6.9 million programmers, just like you, helping each other. Simply use Format Painter to copy the existing conditional formatting to the new data set. Question:I am trying to get Excel to check different boxes and check if there is text/numbers listed in the cells and then spit out «Complete» if all 5 Boxes have text/Numbers or «Not Complete» if one or more is empty. Select the Stop If True check box next to the first 2 rules because you do not want the other rules to be applied when the first condition is met. Click OK twice to close the open windows and your conditional formatting is done!