• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formating using a formula.

Here are 5 examples to help you get started: http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/
 
Here are 5 examples to help you get started: http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/
 
@chandoo, @dan_l

Thanks for that. Basically I want to have a text cell to be formated a certain colour based on whether the text entered is "Yes" or "no" etc.

Bearing in mind that although I am working in 2007, I need it to be compatable with 2003...

Thanks for the great tips and keep up the good work!
 
Bradpallister

In CF just use a simple formula like

=$C$1="Yes" set a format

=$C$1="No" set another format


Any other answer will result in the cells own format being applied
 
@hui

Okey, thanks... but if say C4 was "Yes", how can I make that format row 4? Do I enter the formula in a separate cell or how do I do it?

Thanks very much.. :)
 
Bradpallister

Please read and try the basics at: http://chandoo.org/wp/2009/03/13/excel-conditional-formatting-basics/
 
You must log in or register to reply here.
Back
Top