Conditional Formating??

[Davers]

Hi all...I submitted this same problem yesterday, but I didn't explain myself very well, and the example I had was horrible. So here is my second attempt...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
3	1
4	2														EnterStartRow:	3
5	3														EnterEndRow	7
6	4
7	5
8	6
9	7
10	8
11	9
12	10
13
Sheet1

This is what the sheet would look like after I typed 3 into cell P4, and 7 into cell P5. The formula I need would change what range of cells are highlighted based on what you would put in cell P4 and cell P5. It was suggested that I try conditional formatting, but I couldn't get it to work....any other suggestions??

Thanks,

Dave M.

 

[Juan Pablo González]

On 2002-11-07 10:47, Davers wrote:
Hi all...I submitted this same problem yesterday, but I didn't explain myself very well, and the example I had was horrible. So here is my second attempt...

...table here...

This is what the sheet would look like after I typed 3 into cell P4, and 7 into cell P5. The formula I need would change what range of cells are highlighted based on what you would put in cell P4 and cell P5. It was suggested that I try conditional formatting, but I couldn't get it to work....any other suggestions??

Thanks,

Dave M.

Ok, select A:M, go to Conditional Formatting, and use this formula:

=(ROW(A1)>=$P$4)*(ROW(A1)<=$P$5)

 

[Juan Pablo González]

If you only need to color the range A3:M12 then don't select the entire column but this range, and change the formula where it reads A1 for A3.

 

[Davers]

PERFECT!!!!! Exactly what I needed...I wonder why I couldn't get it to work yesterday....:-/

Thanks again Juan, you save me!!!