Conditional Formatting - change font color in B25 if a separate box B23 says N/A

[H57]

As a novice I want to ask for help in changing the font color in box B25 to red, if box B23 says "Not Applicable". All other variations in B23 (of which there are six) I want the font colour to remain as black.

I can't find the answer in Excels own Help pages!

Thanks in advance

[Fotis1991]

In Conditional Formatting rules use this formula.

Please Login or Register  to view this content.

Choose your color>>ok.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.

[H57]

Thanks so much - I was over complicating the formula

Please mark as SOLVED

Once again thank you Fotis

[Fotis1991]

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[H57]

Thank you I'll remember next time

[Fotis1991]

It would be nice to start from this time!