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 

For conditional formatting:

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

 

Nyssa1585's avatar
Nyssa1585
Copper Contributor
May 30, 2024

dscheikey Follow up question if you have time if I was to put each month on a separate sheet to display that status on the first sheet in L4, how would that array for the Index change in the formula.

 

like in: https://www.dropbox.com/scl/fi/2r4cue9czdbu56ij7qkmp/MDI-RED_Greenseparate.xlsm?rlkey=0msxuez5nr62mv7ada9hwrehx&st=q9sbjp94&dl=0 

  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    May 30, 2024

    Nyssa1585 

     

    Please try:

    =OR(INDEX(INDIRECT(TEXT(TODAY(),"MMMM")&"!A3:AH77"),0,XMATCH(TODAY(),INDIRECT(TEXT(TODAY(),"MMMM")&"!A3:AH3")))="x")