I have created a weekly tracker on Google Sheets, with the days organized in columns K through AI. Each day has three columns dedicated to tasks, assigned personnel, and notes. I have successfully applied a conditional formatting rule to the range L6:O36, which colors the rows based on the assigned person.
However, when I attempt to apply the same rule to the range P6:S36, it does not work. I'm puzzled as to why this is happening. Could you please help me understand the reason behind this issue?
Here is a link to a copy of the spreadsheet: : https://docs.google.com/spreadsheets/d/1eoDD7ODEnBvUCANEaGuJcwCY93DTjuMiDvmQ71G0QY4/edit#gid=1816207673