Greetings! I am trying to add a condition to a formula that will change the bar color based on referencing a cell value of "F" in Column c ($C7). This column allows the project manager a quick view to know who is "field" employee vs. "office" employee. I'm using Office 365.
The basic formula to select dates is:
=AND(task_end>=I$5,task_start<J$5)
Where & how do I incorporate "$c7="F"
Basically, I'm looking for: "IF column c ="F", then format the date range (task_end>=I$5,task_start<J$5) to my desired color.
I haven't been able to find this specific scenarion anywhere. Any help is GREATLY appreciated.
THANK YOU!
The basic formula to select dates is:
=AND(task_end>=I$5,task_start<J$5)
Where & how do I incorporate "$c7="F"
Basically, I'm looking for: "IF column c ="F", then format the date range (task_end>=I$5,task_start<J$5) to my desired color.
I haven't been able to find this specific scenarion anywhere. Any help is GREATLY appreciated.
THANK YOU!