Excel 2010: How do you use Conditional Formatting?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
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?

Post 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
Love PHP. Love CSS. Love learning new tricks too.
All the best from the United Kingdom.
Post Reply