If I have a cell containing a formula A1+A2+A3 which is conditionally formatted to turn blue if the resulting value is greater than (B1*0.7), how do I further expand this formula to incorporate a statement such as 'If C1 = "Turnip" then turn the cell blue only if the resulting value is greater than (B1*0.7+25) ?
I hope I have written this clearly enough to explain what I want to achieve. Oh, and this is not to be used in a turnip counting program if you were wondering. This is a purely hypothetical scenario!
I hope I have written this clearly enough to explain what I want to achieve. Oh, and this is not to be used in a turnip counting program if you were wondering. This is a purely hypothetical scenario!