Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

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
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Rgonzo1971Commented:
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now