Conditional Formatting - excel 2010

Hi,

I have a list of client id's in Column A and in Column B, C & D i have values

If in Column B, the value = 1, i want the adjacent client ID to be highlighted red

How can i achieve this?

Thanks
Seamus2626Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

In Home / Styles / Conditional Formatting / New Rule

Choose Use a formula Insert (if your first client ID is A2) =B2=1 and then format at your convenience)

See example
EE20140305.xlsx
0
 
Seamus2626Author Commented:
Perfect, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.