"conditional formatting" with more than one condition

[sandlinj]

Basically I have a maintenance schedule and I am attempting to highlight,change the appearance, etc of cells in B9:E29 in the picture below if Today() falls within the week number (F8:BE8) and there is also an "x" in that column. Basically in my attached picture, I would like B28:E29 highlighted because today falls within the 47th week (AZ8) and maintenance is due indicated by AZ28, AZ29. Hopefully this made sense to someone. I have tried everything I could think of using conditional formatting and I was about to try and start attempting it from a VBA approach but figured I would see if anyone had a simple solution. Attachment 598875

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context and we can then be certain that what we provide does in fact do what you want.

In essence the structure of the Cond. format formula will be

Please Login or Register  to view this content.

[sandlinj]

That was what I was trying but havent had luck. I will upload the workbook. Thank you for a response.

[Richard Buttrey]

Hi,

Would you confirm the dates in Row 7
I note F7 has a date of 24/10/2018 but then G7 is 7/1/2019
I'm presuming G7 is a typo and it should be 31/10/2018 and then forward in increments of 7 days
I'll also assume that the dates are the week commencing date not the weeke ending date

You have also attempted two different conditional formats with a brown and green format.
However you've only mentioned wanting to identify one condition. I'll work on the assumption that it is only one.

The CF in B9 and applied to $B9:$E76 is

Please Login or Register  to view this content.

[sandlinj]

Whoops sorry about all of the confusion. The date in G7 was actually correct and I had been changing F7 to test. I meant to have the dates row hidden and just use row 8. The multiple attempted conditional formats were what I had been attempting, before I asked for help. Probably should have deleted those (embarrassing). Thank you so much for all of the help. You got me extremely close to what I was looking for. This is what I ended up using to make it work the way I wanted and didnt explain well enough: =OFFSET($F9,0,MATCH(WEEKNUM(TODAY()),$F$8:$BE$8)-1)="X"


Again, thank you very much for your time.

[Richard Buttrey]

Hi,

Yes that will work just as well.
Is 7/1/2019 (the first Monday of 2019) Week 1 and have you changed G8 therefore

The caveat when using the week number is that it should always with your actual w/c date for week 1.