Offset Inputbox function - change cell colour

what is the column in which U,D,L.R is entered and in which column 1,2,3,4 are entered.
I presume the corresponding cell in column D is to be colored.l

let us assume U,D,L,R is entgered in column E form row 5 down and 1,2,3,4 entered in column F

select D5
use conditional formatting
the formla is
=and(E5="U",F5=3)
and click format and choose pattern and choose the color
click add and introduce the second formula etc

but in excel 2003 or earlier only three conditions can be given. I supposein excel 2007 more conditions can be given


formats in D5 canbe copied down as pastesecial-formats.
think on these lines

Thanks for your input. I am planning on receiving the user input via VBA. I will assign a variable as such,

direct = UCase(InputBox("Enter Direction", "Input Direction"))
integ = InputBox("Enter Number", "Input Number")

From here, D8 being my starting point, based on what the user enters I want to go Up, Down, Left or Right. And from the number the user enters, that is cell I want to colour. Considering D8 is the starting point,I would use the Offset function.

Thanks again.