google-sheetsconditional-formatting

Conditional formatting depending on two cells


I am making a google sheet to keep track of when an item goes for repair,

However this would require setting it to every cell where that would be able to happen so 52*52,

So I’m looking to see if anyone has a better solution,

I am more than happy to share an example if needed

This is the current formula which I’ve got which is the following =IF(AND(J2=1,L1=”WK1”)True,False)

Example Link: https://docs.google.com/spreadsheets/d/1mILCI2-Ev2RiTKfL0kG92jZMQmy1jCh6I2_WfH-pDxA/edit?usp=sharing


Solution

  • Here's one approach you may test out:

    =$C4=--regexextract(D$3,"\d+")
    

    enter image description here