Conditional Formatting - excel 2010

Seamus2626
Seamus2626 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
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

Author

Commented:
Perfect, thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial