Coplex conditional formating

[Droon]

Hi community!

I've been working on a excel document for a while, trying to use conditional formatting to highlight areas depending on choices made in lists.

Selection	Correct answer	What one wrong answer look s like now	What I want one wrong answer to look like
f1	f1	f1	f1
b1	b1	b1	b1
w2	w2	w1	w2
a2	a2	a2	a4
c2	c2	c2	c4

<tbody>
</tbody>

So basically what I want to do is to have a conditional formatting that formats the contents only if all five cells are correct.
Due to the policies of my workplace I'm not able to use any type of macros and VBA.

Best regards,
Johan

 

[gaz_chops]

Maybe

=AND(B2=A2,B3=A3,B4=A4,B5=A5,B6=A6)

 

[Droon]

Maybe

=AND(B2=A2,B3=A3,B4=A4,B5=A5,B6=A6)

Thanks for your reply!

Yes that would work for a small data set, what I forgot to mention is that my data set has thousands of entries (grouped as 5 cells) so it need to be some sort of conditional formatting that I can apply to the entire sheet.

I was thinking of something like:

=AND(INDIRECT(ROW()&COLUMN())=$A$2,INDIRECT(ROW()+1&COLUMN())=$A$3)

It accepts the formula, but it doesn't seem to give me anything.
The 5 cells that contain the answer that I want to check against are called $A$2, $A$3, $A$4, $A$5, $A$6

 

[gaz_chops]

Are the groups of 5 separated by other data/blank rows?

Maybe you could post a slightly larger sample.

 

[Droon]

Are the groups of 5 separated by other data/blank rows?

Maybe you could post a slightly larger sample.

	Exp01	Exp02	Exp03	Exp04	Exp05	Exp06
f1	f1		f1	f1	f1
b1	b1		b2	b1	b1
w1	w1		w1	w1	w1
a4	a4		a4	a4	a2
c5	c5		c5	c5	c5
		f1		f1	f1
		b1		b1	b1
		w1		w1	w1
		a4		a4	a4
		c5		c5	c5

<tbody>
</tbody>

They are not separated by blank rows or other data. The first cell in the set will always be named f+number, second cell b+number and so on. Hope it clarifies it a bit.

 

[Droon]

http://tinypic.com/r/1zd6q2x/8

This is what it actually looks like
So with the correct formatting it should only be the second column in Test 7, Exp08 that is formatted, the rest should be white.

 

[Droon]

Anyone else that has any suggestions?

 

[Droon]

A small bump to see if this can get some more help since I'm stuck on my own!

Thanks in advance,
Johan