LinkBack URL
About LinkBacks
I have some dates from B5:B9 and I want to highlight the entire row in yellow if they are within a month and not complete, but nothing happens when I apply this rule:
<code>=AND(MONTH(B5:B9)=MONTH(TODAY()), D5:D9<>"Y")</code>
I have some dates from B5:B9 and I want to highlight the entire row in yellow if they are within a month and not complete, but nothing happens when I apply this rule:
<code>=AND(MONTH(B5:B9)=MONTH(TODAY()), D5:D9<>"Y")</code>
Just select cells B5 to B9 and apply this CF formula
Formula:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi,
In B5 add this formula using the Formula is option in cond. formatting
Formula:Please Login or Register to view this content.
Set the format to yellow and the Apply this to rows 5:9, or perhaps just B5:D9
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I think the code fails due to the ranges being included in the code. Try the following steps and let me know if it works better. (First, remove any conditional formatting already applied on the cells).
1. Select the range of cells upon which you want to apply the conditional format. For the sake of the example, I will assume you are selecting cells A5:G9.
2. Go to Conditional Format --> New Rule --> Use a Formula...
3. Enter the following formula, taking note of the '$'
4. Select your format.
Please Login or Register to view this content.
Let me know if this works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks