i've looked through several pages of past threads and found some that are similar to this, but none that are exactly the same, i swear. please don't chastise me for posting a repeat.
i have cells C26:C30 containing percentages. these 5 percentages should add up to 100%, (or simply 1 in excel think).
how would I write a formula in C25 that says:
IF SUM(C26:C30)=1, turn C25 green, when SUM(C26:30) is <1<, turn C25 Red.
How would i go about doing this? thank you very much in advance.
Bookmarks