How to make this work? IF, AND function, conditional formatting? 3 quesitons.

Hello!
I started to "play" with excel so it will make my work (and hopefully others) easier. Got the idea, but lack of knowledge.
So I would like to accomplish this:
1. IF B=XXX and C=YYY color background
I have come up with somehting like this: IF(($B=XXX)AND($C=YYY))
Obviously wrong, I wanted to put this to Conditional formatting and set the color there.
2. I got a column with dates in format yyyy-mm-dd hh-mm I would like the dates that are less than one day to NOW mark red. I'm pasting the dates manually.
3. IF B=ABC > F=AAA
IF B=BCD > F=BBB
There are about 20 diffrent codes in B column and about 15 in F column, as some of B codes have the same value in F

Hope this is understendable :D THank you very much in advance!

1) AND(($B=XXX),($C=YYY))
2) =(A1-Now())>1
3) What do you mean by ABC or AAA? Greater than has to relate to numbers.

Always beat me to it NBVC

Thank you guys! As I'm currently on holiday, I'll get back to it when I'll be at work :P About the 3rd point here is an example (column A with no, column B with letters):
1 A
2 B
3 C
4 D
5 A
6 B
7 B

The thing is that when I put a value manually in column A I would like to get a value in column B according to a predefined list with values for "numbers(as numbers there will be a list of customers)" and "letters(as letters there will be a list of managers which work for a specific customers, some customers have the same manager)".

Cheers!