NewbieExcel123
New Member
- Joined
- Jul 30, 2024
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Hi all,
I've had a long search and can't get my head around this, I believe it's a combination of Sumproduct or Sumtotals I need but I'm not too clued up to get it working.
I have a conditional formatting that looks for a value in column C and when it appears in column W, it checks the column next to column X (currently column Y) to see if it shows the text "In Office", if no, it changes the colour of a cell in column C to red.
I've tried to reference the days of the weeks cells as offset as I want to hide 5 columns (days of the week) as each week passes, so when the new week shows to the right of column X.
But I'm unsure how to do this, unfortunately I'm unable to upload photos or workbooks.
=COUNTIFS($W:$W,"*"&$C3&"*",OFFSET($X:$X,0,1,),"In Office")=0
Thank you for any help you can offer.
I've had a long search and can't get my head around this, I believe it's a combination of Sumproduct or Sumtotals I need but I'm not too clued up to get it working.
I have a conditional formatting that looks for a value in column C and when it appears in column W, it checks the column next to column X (currently column Y) to see if it shows the text "In Office", if no, it changes the colour of a cell in column C to red.
I've tried to reference the days of the weeks cells as offset as I want to hide 5 columns (days of the week) as each week passes, so when the new week shows to the right of column X.
But I'm unsure how to do this, unfortunately I'm unable to upload photos or workbooks.
=COUNTIFS($W:$W,"*"&$C3&"*",OFFSET($X:$X,0,1,),"In Office")=0
Thank you for any help you can offer.