Use Conditional formatting to insert text in cell

[Golaidron]

Hi guru's.

Is it possible to get conditional formatting to insert text in addition to color?
Would like to have columns in the Gantt form marked with color and description of public holidays

I don't want to insert text or formulas into the gantt form


Hope to hear from you guru's soon.

Best regards
Golaidron

 

[Peter_SSs]

Is it possible to get conditional formatting to insert text in addition to color?

No. As per its name, conditional formatting is for cell formatting not cell content

I don't want to insert text or formulas into the gantt form

Why not?

 

[Golaidron]

No. As per its name, conditional formatting is for cell formatting not cell content

Why not?

I just want datavalidation in the cells that the date is not a holiday.

Is there a if formula that i can use?

If date = holiday then indeks and match
If date = not a holiday, then datavalidation active with list

 

[Peter_SSs]

I just want datavalidation in the cells that the date is not a holiday.

Is there a if formula that i can use?

If date = holiday then indeks and match
If date = not a holiday, then datavalidation active with list

I'm lost. That seems to have nothing at all to do with the thread title or what was written in post #1.

 

[Golaidron]

I'm lost. That seems to have nothing at all to do with the thread title or what was written in post #1.

Me too

First I wantet to get conditional formatting to insert text into cell that are equal to holiday's. You said that couldn't be done.
Then i was wondering if I could use a formual that inserts holiday decription when the date match to a holiday and if not a holiday i want it to activate datavalidation in the cells