Colour to dispay based on the list of value selected in 2 column

[chakkaravarthy.m]

Color to display based on the list of value selected in 2 column. defintion of the color are in the another sheet.

Ref the excel attached for examples

[AliGW]

You will need three CF (conditional formatting) rules, one for each colour:

=OR(AND(A2="A",B2=1),AND(A2="b",B2=2))

=AND(A2="c",B2=3)

=AND(A2="d",B2=4)

[chakkaravarthy.m]

Ali Thanks, it worked perfectly.

for the blank rows, the formula column is displaying #N/a, how to get rid if this ?

[Cleetus09]

Ali Thanks, it worked perfectly.

for the blank rows, the formula column is displaying #N/a, how to get rid if this ?

add an =iferror(formula),"result you want")

example

=Iferror((formula),0)

will turn your #N/A to 0

[FDibbins]

Based on Ali's suggestions...
=OR(A2="",B2="",.........