Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm designing a shift roster and want to ensure person working in C shift (night shift) is not assigned shift A (morning shift) because it becomes a continous shift.

This means, if value of cell A12=C and B12=A then B12 should be highligted as RED.

Take example below:

Col A Col B 
C A  B C B B B B A B C A

It should throw me an error on the first and last cell of column B.

share|improve this question
    
Please fix your formatting, your example isn't clear. –  slhck Dec 22 '12 at 9:49

1 Answer 1

Try this

Select column B then in "Home" tab select "Conditional Formatting" > New Rule > "use a formula to determine which cell to format" > in the box below type this formula

=AND(A1="C",B1="A")

and then click "Format" button to set required format (red fill)

That will then highlight any "A" entry in column B where column A in same row = "C"

Instructions apply to Excel 2007 or later

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.