Conditional formatting with multiple vlookup columns

Question

I am looking to create a conditional format for a sheet based on several things.

Sheet 1:

Ref: Date = Col1 Row1

    Date    Census          RN On Schedule                
            7a  3p  11p     7a  3p  11p     
    1-Oct   8   8   9       8   8   9       
    2-Oct   10  14  13      13  16  13      
    3-Oct   10  12  12      12  12  10      
    4-Oct   12  10  10      11  11  10      
    5-Oct   10  11  11      11  12  11      
    6-Oct   10  11  14      11  12  12      
    7-Oct   13  12  12      12  14  12      

Sheet 2:

Ref: Census = Col1 Row1

Census  RN Staffing Needs       
        7a  3p  11p     
1       2   2   2       
2       2   2   2       
3       2   2   2       
4       3   3   2       
5       4   4   3       
6       4.5 5   5       
7       5   6   6       
8       6   7   6.5     
9       7   8   7       
10      8.5 9   8.5     
11      10  11  10      
12      12  12  11.5    
13      12  12  12      
14      12  12  12      
15      13  13  13      
16      13  13  13      
17      14  14  14      
18      14  14  14      

So here is the question.

1, , 2 , . , ( , 1 - 8 @7) 2. RN RN ( RN, 6 @7a; RN On Schedule, 8). RN 1 (F3 1-Oct) , RN 2 , . , , . , .

vlookups index/matches IF- IFERROR ..... . !

Answer 1

, , , .

EDIT. .

(E3: E9) Sheet1. , > . F G, vlookup.

, F =F3<vlookup(C3,Sheet2!$A:$D,3,0)

1

, I3, (K9)

E3: G9 .

2 ( ).