Forum Question: How Do I Do Conditional Highlighting If a Vehicle Reg Meet Spec Criteria

I have cell B6 which has Vehicle Registration Number in. Example: CE63ANX. The spec type is 6. There are 7 different specs and each has a different colour to indicate vehicle Max Train Weight.

I have a lookup formula that looks for that vehicle reg in another table in a separate sheet and returns the spec number in cell C6.

I want Cell B6 to be blue.

Any idea how I can achieve this please

Regards
David
—–
David

Comments: 2 Responses to “How Do I Do Conditional Highlighting If a Vehicle Reg Meet Spec Criteria”

    5/10/18 @ 2:13 pm

    You can’t. Conditional highlighting will allow you to change the color of that cell, but not another cell. So you’ll have to settle for cell C6 to be blue.

    Or, you can have a completely different column with an indicator in that.

    Check out my video on this: Numbers Conditional Highlighting Based On Other Cell Values.

    David
    5/10/18 @ 4:06 pm

    I have solved this with several formulas. Please send me a email so I can give you my solution.

Leave a New Comment Related to "How Do I Do Conditional Highlighting If a Vehicle Reg Meet Spec Criteria"

:

:

:


0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)