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
Excel 2010: How do you use Conditional Formatting?
Moderator: General Moderators
-
simonmlewis
- DevNet Master
- Posts: 4435
- Joined: Wed Oct 08, 2008 3:39 pm
- Location: United Kingdom
- Contact:
Excel 2010: How do you use Conditional Formatting?
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
All the best from the United Kingdom.