Conditional formatting

[jhow659]

A1= STYLE A
A2= STYLE B
A3= STYLE C
A4= STYLE D
A5= STYLE E
A6= STYLE F
A7= STYLE G
A8= STYLE H
A9= STYLE I
A10= STYLE J


B1= 304
B2= 111
B3= 205
B4= 316
B5= 524
B6= 308
B7= 209
B8= 116
B9= 415
B10= 420

Conditions: STYLE E can only be a 401, 402, 403, 404, or 405.

I want to use conditional formatting to highlight cells. column A could be in any order or missing styles each time so I need excel to look through A1:A10 to find STYLE E for example. if it finds STYLE E I want it to look at column B and find the cell in the same row as STYLE E and highlight it only if it does not meet the conditions.

 

[jtakw]

Hi,

Are you going to have a different list of conditions for every Style?

 

[jhow659]

yes each style will have to have its own conditions.

 

[jtakw]

Will you have a list of all the conditions for each Style in the sheet somewhere?
May be show a sample...

 

[FDibbins]

you do klnow you will need a new rule for each condition, right?

 

[jtakw]

Not necessarily, if there is a table set up for all the STYLES and Conditions...

 

[FDibbins]

Not necessarily, if there is a table set up for all the STYLES and Conditions...

What I meant was, if the OP requires different colors/fonts etc, a new rule will be needed for each

 

[jtakw]

, yeah, waiting for OP's response...