How to get Conditional Formatting to do this

Hello there,

I'm looking to do the following in excel.

I have a column which can take a few values. I want the two adjacent-to-that-column cells to take on specific formatting depending on what the value in said reference cell in the column is.

I only know how to make the change in the reference cell itself, not how to make it influence a different cell, nor how to do this for each set of cells in an entire column.

So:

	A	B	C
1	in	lorem	ipsum
2	on	dolor	sit
3	out	amet	consectetur

If
A1 = "in" or "on", B1 = blue text + white fill, C1 = blue fill + white text
A1 = "out" or "under", B1 = red text + white fill, C2 = red fill + white text

Same for about 3000 rows individually.

Help?

A million times thanks!

I know just enough to fulfill my purpose.

---

Out of curiosity, in case I'll ever need it:

Originally Posted by Tony Valko

Select the ENTIRE range B1:C10 starting from cell B1.
Cell B1 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

"Relative to the active cell", what does this mean?

Thinking out loud:

B1 uses:
=OR($A1="In",$A1="On")

So in the next row (B2) it will apply:
=OR($B1="In",$B1="On")

What does it do about C1? What if I wanted a shift/fill/relativity by columns? It will do that automatically?
And what if you didn't want the condition to be relative? So to check one cell (say, a sum?) as reference and then have it influence a range?

Since this is just extra information I'll be equally content if you had a link where it is all explained. It'd go in my favorites anyway.

In any case, my issue is solved. I'll save a lot of time.
Thank you so much.