Conditional Format help...please

Hi All,

Firstly I dont know if I am in the right section to be posting for the help I need. Secondly I am very new to using Excel. Never really used it before.

I have been given the task to make an Access Card Register.

I have done almost everything I need to do with it, except for one problem, I want to conditionally format a whole stack of columns and rows. I have only managed to get this to
work for one column. I cant get to work for the rest.
Basically, from F3 to F400 does what I want it to do with colors and dropdown list but what I really want to do is have it doing it from F3 to IV400. I have managed to get the dropdown lists to work
but not the colors.
I am still very very new to excel, so if someone could explain it in plain english, that would be great.
I have also attached the file I am working on for someone to look at and possibly sort out.