Forum Discussion

Nyssa1585's avatar
Nyssa1585
Copper Contributor
May 29, 2024
Solved

If a "x" value is present and the column header is today's date how do we display true/false

I have a workbook that I am trying to update to display the status (red or green) in cell AB1 of the lab in a singular cell based on =Today(). The table is a calendar format but due to some other piv...
excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    May 30, 2024

    Nyssa1585 

    For conditional formatting:

    =OR(INDEX(A3:PN77,0,XMATCH(TODAY(),A3:PN3))="x")

     

dscheikey's avatar
dscheikey
Bronze Contributor
May 30, 2024

Nyssa1585 

Question no. 1: Could you please upload the worksheet without data here or to another file hoster so that I don't have to spend a lot of time recreating the scenario for the solution. Thank you.

Question no. 2: Did I understand correctly? If there is an "x" anywhere in today's column, AB1 should be given the cell colour red, otherwise green? Does the status field also exist for the other months or does only this one apply to January for the whole year?

 

Nyssa1585's avatar
Nyssa1585
Copper Contributor
May 30, 2024

dscheikey 1) Not sure why this page is saying any .xlsm,. .xlsx or any other file type is not supported but hopefully this host site will work instead: https://uploadnow.io/f/zCH1Shq

 

2) you are exactly right, if no x is present it should be green. The idea would be to have one status bar for the whole year. 

 

Thank you for your time!

 

Resources