Today format in color

Closed
Andy - Sep 16, 2010 at 11:55 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 19, 2010 at 07:59 AM
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

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 19, 2010 at 07:59 AM
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.
0