Conditional formatting based on Status of a different cell
Is there a way to set a conditional format for a cell based on the data in another cell?
For example I have rows of actions that need to be completed ;
My columns have countries listed in one column "Belgium Date complete" then a second Column that is "Belgium Status".
I can create a conditional format that updates the cell "Belgium" grey when it changes to "complete" , but I also want to color the cell that is for Action 1, Belgium Date grey as well. BUT I ONLY want to change that one cell. I do not want the formatting to apply to all the cells in the row nor to the entire column.
The reason we are not using project is that the client wants to be able to see all the tasks "at a glance" and once the state is updated, I would like the associated date to update as well.
Snip is attached
Help Article Resources
Check out the Formula Handbook template!