I have a live workbook which, is updated weekly with information.
Is there a way to apply a conditional format to the worksheet based on criterion in Column i which has a drop down list of 3 options.
Option 1 - COPF, Option 2 - EOPF, Option 3 - LIG.
The worksheet uses the columns A - to - N
I am trying to find a way to add different colors against each of the 3 criteria ( Amber - COPF, Light Blue to EOPF & Light Green to LIG)
I only want the background color to be applied to each Row in cells A-N.
Is there a way to apply a conditional format to the worksheet based on criterion in Column i which has a drop down list of 3 options.
Option 1 - COPF, Option 2 - EOPF, Option 3 - LIG.
The worksheet uses the columns A - to - N
I am trying to find a way to add different colors against each of the 3 criteria ( Amber - COPF, Light Blue to EOPF & Light Green to LIG)
I only want the background color to be applied to each Row in cells A-N.