Coloring cells based on date range and adding a shape at a certain date

**moomphas** · 05-23-2018, 04:23 AM

Hello,

I have the following conditional formatting rule to color cells based on range defined in cell G as start date and H as end date:

Please Login or Register  to view this content.

Works perfectly fine.

Now, I have a date in F column, and I would like to draw a shape (diamond) on that date. Can't figure a way to do it

picture.png

Any ideas?

**kersplash** · 05-23-2018, 04:26 AM

Attach a sample workbook showing what you are trying to achieve.

**moomphas** · 05-23-2018, 05:17 AM

Originally Posted by kersplash

Attach a sample workbook showing what you are trying to achieve.

Attached in the first post now

Re: Coloring cells based on date range and adding a shape at a certain date