Hi,
How can I enter a formula in conditional formatting that gives an orange background to a cell if the cell is blank and if the cell also is in the column of the current month (row one has the month)?
That is, how can I write the following formula?
Thanks!
Please Login or Register to view this content.
/Daniel
Try something like this in "Formula is"
=AND(MONTH(TODAY())=MONTH(A2),C2="") set fill to Orange
Where A2 has a date with the same month as today and C2 is blank
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks!
/Daniel
No problem - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks