Conditional Formatting & IF Functions

[almo89]

Hello,

If someone could please help me develop a formula for my excel it would be greatly appreciated (either a youtube link or exlpanations would be of great assistance). I believe it has to be through the conditional formatting tool and IF functions but I may be way off.

What I am trying to do is have certain cells highlight only if i select a certain entity type (from a drop down menu I created) in column B (named "entity type" below).

For example, if i select the dropdown for individual in B2 i want the blank cells E2 and F2 to highlight and if i select regulated in B3 i want C3, D3 and G3 to highlight. So essentially based on what i select in column B (10+ options) it auto-highlights under the requirements.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Entity Type[/TD]
[TD]Proof Reg[/TD]
[TD]Sig list[/TD]
[TD]ID[/TD]
[TD]Address Proof[/TD]
[TD]Details[/TD]
[/TR]
[TR]
[TD]Joe Random[/TD]
[TD]Individual[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Random Ltd[/TD]
[TD]Regulated [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank-you to anyone who can provide any help!!

 

[Andrew Poulsom]

Welcome to MrExcel.

You can use conditional formatting formulas like:

=$B2="Individual"
=$B2 = "Regulated"

applied to E2:F2 and C2:D2,G2 respectively.

 

[almo89]

Thank-you for the help!