Forum Discussion

Ava2501's avatar
Ava2501
Copper Contributor
Feb 28, 2024

Formula for changing colour of row based on drop down menu

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.

 

  • Ava2501 

    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.

Resources