Forum Discussion
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 ...
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.