Hello!
I hope this is in the correct section.
I am hoping you can help me with some conditional formatting on some cells of mine.
Below is my spread sheet, the formatting needs to be on the sheets named with a month, on each month at the bottom of the sheet there is a table with the title "Pause Data For Yesterday".
Within this table I have "Pause Type" and "Time in Pause".
I want my conditional formatting to highlight the "Time in pause" box read with bold white writing when the word "30 Minute Lunch" in the column named "pause Type" is present and when the column "Time in pause" is greater than 00:30:30
I have tried using the =AND function and the =SEARCH function in the conditional formatting but I cant get it to work.
Can anyone help?
Bookmarks