Conditional Formatting

[smarie123]

I know this is probably simple, but my brain is totally fried...
I have master spreadsheet with several data validation elements pulling from hidden worksheets. A snapshot of one of those worksheets is below

-- removed inline image ---

The option on the master worksheet is for people to select one of these employees from a dropdown menu. When an employee is elected all the information to the right is auto populated on the master. The final column where you see "SC" I a new addition. What I need is when someone selects an employee that has SC n that column the name needs to turn another color. I know it's something with conditional formatting I just can't ever figure out which rule it should be.

Hope this made some sense!! THANKS!!

 

[Ragnar1211]

The trick to working with conditional formatting is that you need to write a formula that resolves to either TRUE or FALSE.

For example =A1=10 will resolve to TRUE if A1=10 and will resolve to FALSE if A1 is any other number

Highlight the cells you want to format and type the formula that resolves the problem you describe.

An easy way to test your formula is to type it into a cell to see if it gives the desired result.