Coloring area based on values

**JoakimBugge** · 02-10-2020, 07:00 AM

Hi,

I have the following table on the attached workbook.2020-02-10_11-58-15.jpg

Can you help me how excel can automatically color the week cells, based on the entered start and end week?

Thanks!

**Pepe Le Mokko** · 02-10-2020, 07:22 AM

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

**KOKOSEK** · 02-10-2020, 07:36 AM

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Month		Jan					Feb				Mar
2	Week		1	2	3	4	5	6	7	8	9	10	11	12	13
3	Start week	End week
4	1	7
5	5	11
6	3	8

Macro colouring weeks as declared colour in col A.

**Pete_UK** · 02-10-2020, 07:49 AM

You can do it in one operation using conditional formatting with this rule:

=AND(C$2>=$A4,C$2<$B4)

This should apply to the range $C$4:$R$5, though this will just give you one fill colour for that range.

Hope this helps.

Pete

**davsth** · 02-10-2020, 07:50 AM

Agreeing with Pete but a slight amendment
=AND(C$2>=$A4,C$2<=$B4)

Coloring area based on values

LinkBack

Thread Tools

Rate This Thread

Display

Coloring area based on values

Re: Coloring area based on values

Re: Coloring area based on values

Re: Coloring area based on values

Re: Coloring area based on values

Thread Information

Users Browsing this Thread

Similar Threads

Coloring rows based on values in columns (+ wildcards)

[SOLVED] Coloring rows of cells based on certain cell values

[SOLVED] Conditional Formatting - Coloring Cells based on Values

Coloring Interior Fill based on range values

Excel 2007 : Coloring area in line chart

Custom Coloring an area chart with VBA

Coloring Chart Area Dynamically?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions