Feb 28 2024 01:46 AM
Hi everyone
I have managed to make a drop down list but I am struggling to find the formula to change the row of the table to a different colour based on the drop down menu.
For reference I have Complete, In Progress, and Not started in my drop down menu and want to be able to change the whole row to green for complete, yellow for in progress and red for not started. I have managed to change the colour but only for the drop down menu, not for the whole row.
Thanks in advance.
Feb 28 2024 02:38 AM
Formula for conditional formatting rule could be like
=$H2="Complete"
applied to the range as $A$2:$H$100.
Just be careful with combination of absolute and relative references.