Today format in color

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I want to compare cell I3 to today's date and if it equals to today, I want I3 cell to turn RED (CAPITAL font) with highlight Yellow and say "GO" . Can someone help?

If I could expend it, if I3=today(), Can a picture of a light bulb appear in the cell?

Thanks to all responders in advance.

Andy

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you could do so with macro. How ever if you use conditional format, you can change the color and format the cell without any coding but you will not get all that you desire.