Highlight cell by certain colour based on 3 criteria

**Shonky** · 10-01-2021, 03:14 AM

Gday all,

I have a table that requires some assistance. I have cells (A2:A14) that needs to be colour coded based off the cells K2:K9 but have to meet certain requirements within the data set from E2:G14. For an example, A5 will need highlighted the colour within K6 because it fulfills the requirements for that colour being its a D (E5), Int (F5), and Tall (G5). The different criteria is tabled within the cells M2:M9, I can arrange them as need be, just need the starting formula to make it all work.

Any and all help is always appreciated.

Thanks,

Shonky

**AliGW** · 10-01-2021, 03:24 AM

You will need to set up a rule for each colour. To help us help you, please manually shade the table so that we can see what we are aiming for.

**JohnTopley** · 10-01-2021, 03:35 AM

For A5

Select A2:G14

CF formula

=AND($F2="Int",$G2="Tall",$E2<>"G")

Fill: Purple

**JohnTopley** · 10-01-2021, 03:40 AM

For "Pink"

=AND($E2="G",$F2="Int",$G2="Tall")

For "Red"

=AND($E2="G","$F2=Int",$G2="Standard")

etc

**Shonky** · 10-04-2021, 08:19 AM

Will I have to write a rule out for every letter ie =AND($E2="A",$F2="Int",$G2="Tall")
=AND($E2="B",$F2="Int",$G2="Tall")
Or can I give it a series to check over? ie from A-F then H-M?

**AliGW** · 10-04-2021, 08:22 AM

You could try this:

=AND(OR($E2="A",$E2="B",$E2="C",$E2="D",$E2="E",$E2="F"),$F2="Int",$G2="Tall")

**JohnTopley** · 10-04-2021, 08:46 AM

see this ...

=AND($F2="Int",$G2="Tall",$E2<>"G")

i,e. therefore must be A=F, H-M

which is why I used this example

Your initial post excluded L & M examples so may need to Exclude as above

**Shonky** · 10-04-2021, 08:53 AM

Thank you so very much for your assistance on this one. I'll be able to make good use of these formulas for years to come.

**AliGW** · 10-04-2021, 08:54 AM

Thanks for the rep.

**JohnTopley** · 10-04-2021, 08:56 AM

And thanks from me for the rep!

Highlight cell by certain colour based on 3 criteria

LinkBack

Thread Tools

Rate This Thread

Display

Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Re: Highlight cell by certain colour based on 3 criteria

Thread Information

Users Browsing this Thread

Similar Threads

dynamic cell updates based on highlight colour of previous cell

Format a cell with text based on another cell's highlight colour?

[SOLVED] CF cell highlight based on another columns colour

[SOLVED] Conditional Formatting - Highlight cell based on two criteria

highlight cell based on criteria

Locate and colour cell based on a number of criteria in other cells

Highlight or colour a cell or cells based on cells in another range.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions