Auto Populating/ formating Fields

I have a project at work I am trying to finish. I need to be able to auto populate/format fields on a spreadsheet. I attached a copy of the sheet I am working on. I emulated what I want on the first sheet and the second sheet contains what I have. As information is populated on column F, I would like columns N, O, & P to auto populate as well as format using pre-defined criteria foubdin rows 2, 3 , & 4 Column B. I may need an additional table in the mix. Any help would be greatly appreciated.