Question re Conditional Formatting

[007juk]

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

[WinteE]

Posting your file would help to make it clear to us.

[007juk]

The highlighted cells (sheet2) are the temporary employees, thanks.

[Bryan Hessey]

The highlighted cells (sheet2) are the temporary employees, thanks.

Hi,

in the training sheet tab, rightmouse and select View Code

copy

Please Login or Register  to view this content.

to there, watch for duplicate first and last lines.

That should highlight your A2 cell as requested.

---

[007juk]

Bryan,

Many thanks that code done the trick, Don't have any experience with VBA, but was the code basically looking in sheet2 for a cell with the colour Red, similar to a vlookup. If I wanted to change the colour how would I do that is there a list that assigns each colour with a number.

I have another query re workbook you might be able to help me with.

1. Some types of training don't require a refresher course, how can I populate column 'D' with the following text (not required)rather than populating with a refresher date.
Can I do this - use conditional formatting. Just enter 'not required' in the cell within the data sheet and format accordingly.

2. Certain employees don't receive training due to their post. How can I populate column 'D' with a particular colour to indicate this.

Thanks again.

[Bryan Hessey]

Bryan,

Many thanks that code done the trick, Don't have any experience with VBA, but was the code basically looking in sheet2 for a cell with the colour Red, similar to a vlookup. If I wanted to change the colour how would I do that is there a list that assigns each colour with a number.

I have another query re workbook you might be able to help me with.

1. Some types of training don't require a refresher course, how can I populate column 'D' with the following text (not required)rather than populating with a refresher date.
Can I do this - use conditional formatting. Just enter 'not required' in the cell within the data sheet and format accordingly.

2. Certain employees don't receive training due to their post. How can I populate column 'D' with a particular colour to indicate this.

Thanks again.

Hi,

for the colours see http://www.mvps.org/dmcritchie/excel/colors.htm
the 3 = Red and the 15 = light gray, these can be any value required.

For column D, you could use an If that firstly sets 'not required' for the correct user position, or sets 'not required' for the course name, or selects / calculates the refresher date.

Not sure why you would need to further colour that, but you could then Conditionally format the column to your colour if Cell Value = 'not required'

hth
---