Conditional formatting Gantt chart with text

[pdsmith]

Hi everyone,

I am working with a schedule spreadsheet and currently have a condtional format to highlight a cell in the date range: =IF($B11>=I$10, $B11<J$10), where column B is my date column. This works great to highlight the cell, but i am wondering if I can also add text to the cell so that I can run a countif function to total amount of tasks in a certain date range.

Thanks in advance!

 

[Fluff]

Not with conditional formatting, but you could use the same formula in the cell like

=IF(and($B11>=I$10, $B11<J$10)","Y","")

 

[pdsmith]

Need it to be in conditional formatting as that is how the cells are getting "highlighted" on the schedule. Not sure if this is even possible, but the code I posted are the green cells. I want to put one letter in each green cell, color it the same as the background, so I can then count the number of tasks by month.

 

[Fluff]

As I said, you cannot do that with conditional formatting, but you can put a formula in the cell to return a value.

 

[pdsmith]

Formula you posted, is breaking, remove the " after the )?

 

[pdsmith]

Also removing the extra " and putting that equation into an already highlighed cell is not putting a Y in the cell

 

[Fluff]

Are you putting the formula into I11 & then dragging down & across? As it works for me after correcting the typo

Fluff.xlsm
	A	B							I	J	K	L	M	N
10									03/03/2024	10/03/2024	17/03/2024	24/03/2024	31/03/2024	07/04/2024
11		05/03/2024							Y
12		18/03/2024									Y
Data

Cell Formulas
Range	Formula
I11:N12	I11	=IF(AND($B11>=I$10, $B11<J$10),"Y","")

 

[pdsmith]

Working but removing my conditional formatting, which defeats the purpose. Found a different way to track, thanks

 

[Fluff]

Glad you sorted it & thanks for letting us know.