Change cell background when using multiple values

[sadsfan]

I have some data in a column (test scores) that I want to group together and then for a cell background to change colour when another cell in the same row meets a certain condition. For example:

I want to say that if cell b1 has a value of 7,9, or 11 I would like that cell to change colour when another cell in the same row or specified data range has the value of 19, 21 or 23.

If cell b1 has a value of 13,15 or 17 I would like that cell to change colour when another cell in the same row or specified data range has the value of 25, 27 or 29.

Is it possible to do this, and if so how!?

Thanks

 

[Jerry Sullivan]

If you have xl2007 or later you should be able to accomplish this using Conditional Formatting (CF). You make a series of rules that, if true, would color the cell based on your specified format for that rule.

Just let me know if you need help doing that.

 

[sadsfan]

Unfortunately I only have 2003, I tried using CF but it didn't work as I needed to change the cell background colour based on the values in another range of cells.

 

[Peter_SSs]

Unfortunately I only have 2003, I tried using CF but it didn't work as I needed to change the cell background colour based on the values in another range of cells.

Excel 2003 shouldn't be a problem unless you want to apply more than 3 different formats. For the sample below I selected B1:B4 and applied the Conditional Formatting shown. Is that the sort of result you are after?

Excel Workbook
	A	B	C	D	E
1		9		21
2		25		23
3		7		3
4		11		19
5
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Formula is =AND(OR(B1=7,B1=9,B1=11),OR(D1=19,D1=21,D1=23))	Abc

 

[sadsfan]

I'll try that, thanks.