Page 1 of 1

Excel 2010: How do you use Conditional Formatting?

Posted: Thu Feb 21, 2013 4:26 am
by simonmlewis
Hi.

I need to set a row as a background color, if one cell contains a specific word. I set that cell where the word is, to the color - but not other fields.

Also, if that cell contains "fred", can I set another field to use one formula - but if that cell doesn't contain that word, then use another formula?

ie: if (B37 CONTAINS 'FRED'), ($C37 * .25), ($C37 * .75)

So if it has FRED it is, do the forum $c37 * 0.25. But if it doesn't, then $C37 * 0.75.

Thanks