Cell formatting by formula or macro?

[Artisan]

Hi,

I was hoping someone can help me please.

A1=text A2 will either be "yes" or "No"

What I want to do is format A1 by either a fill colour or text colour. Any type of format I guess. If A2 is "Yes" then A1 is green and If A2 is "No" then A1 is red.

Many thanks in advance and probably sorry for being a bit thick.

Mark

[deadlyduck]

You can achieve this using Conditional formatting:

Select cell A1|Click Format| Conditional formatting..
Change first field from Cell value is to Formula is
Enter this into second field: =a2="Yes"
Click Format button
Click the Patterns tab and choose your colour for when A2 is Yes
Repeat the process by clicking the Add>> button to add a second conditional format for when A2 is "No"- just change the desired pattern colour

Note that Excel may 'mess up' the =a2="Yes" formula you enter the first time by automatically inserting extra apostrophes. Delete these manually by going into the conditional format dialog.

[oldchippy]

Hi,

Something like this

[Artisan]

Thank you.

[oldchippy]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save