Conditional Formatting Calculating Only Selected Cellss So I have a situation wh

Question

Conditional Formatting Calculating Only Selected Cellss

So I have a situation where I need to calculate the % by Vote Winner bby simply dividing the winner (highlighted cell), so it's either McCain/Palin or Obama/Biden with the Total Votes, and convert it to percentage form. The problem that I'm facing is that the cells are not fixed, meaning that it can I can't use simply one formula and drag it down to the whole entire row, since there are two different possibilities. Do I need to manually type of the formula for the highlighted cell in McCain/Palin, and stop in the 4th row, then type in another formula to calculate for the Obama/Biden and stop in the 10th row, or is there an easier method for this???

Conditional Formatting Calculating Only Selected Cellss So I have a situation where I need to calculate the % by Vote Winner bby simply dividing the winner (highlighted cell), so it's either McCain/Palin or Obama/Biden with the Total Votes, and convert it to percentage form. The problem that I'm facing is that the cells are not fixed, meaning that it can I can't use simply one formula and drag it down to the whole entire row, since there are two different possibilities. Do I need to manually type of the formula for the highlighted cell in McCain/Palin, and stop in the 4th row, then type in another formula to calculate for the Obama/Biden and stop in the 10th row, or is there an easier method for this???

Explanation / Answer

It looks to me like the CF is predicated simply on which is the larger of the 2 values in each row of columns 2 (B?) & 3 (C?). Your formula needs to be constructed using the same condition, not the formatting itself :-)

Based on your screen shot & assuming the column headings start in cell A1, all you need to do is construct a basic IF() function in cell K:

=IF(B2>C2,B2/J2,C2/J2)

Copy the formula down column K, then Format the cells containing the formula using Format> Cells - Percentage.

Hope this help:-)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.