I have two sheets, sheet one contains a personnel roster and the other (sheet 2) contains a section with drop-down menus to fill in the values listed in the personnel roster. I would like to be able to have the personnel roster values be filled with a color (green) when I select that value to be placed in sheet 2 and remain another color (red) when not placed in sheet 2.
For example:
Sheet 1: Sheet 2:
John Doe [GREEN] John Doe
Jane Doe [RED]
Thank you.
With the list of names on Sheet1!A1:A2 enter in B1 and fill down. This will result in TRUE or FALSE
Formula:
=A1=Sheet2!$A$1
on Sheet2!A1 have a Data Validation drop down with the list of names on Sheet1
Select Sheet1!A1:A2 and in Conditional Formatting, New Rule, Use formula... enter
=B1=TRUE then choose Green for the formatting.
With the same selection create another new rule using a formula
=B1=FALSE then choose Red for the formatting.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ElectricChode 
Register To Reply
Bookmarks