Hi,

Looking to highlight a cell red when condition is true.

I have a workbook than conatains two sheets, The first sheet (sheet1) is my frontpage and the second sheet (sheet2) is my data sheet.

Sheet2 contains a list of employee names ans sheet1 has a combo box and populates cell A2 in sheet 1 with names.

I have twelve employees who are temporary and when I select them from the combo box I want cell A2 to fill Red in colour. I used conditional formatting with the equal to function, but it only lets me enter one name or three conditions.

Basically I want to use the same fill colour for each employee who is temporary. Thanks