Hello All , I have a conditional formatting problem .
I am building an app that records Start and stop times on tasks.
I have 3 sheets one a parent sheet “JOBS”
and one a child sheet “TASKS”
and another which is the form / sheet FLOOR ACTIVITY that has start and stop buttons referenced on the TASKS
I have successfully formatted the FLOOR ACTIVITY
rows that have a blank [Stop] Column
as green (working on now ) however they are only green in the view using that table
I want that green to show across the Table views
eg in the TASKS
View and the JOB view they are all referenced to each other ? and
from there can the JOBID that has the same Task ID also be green