VBA Conditional Formatting of Cells within limits

[seanfoxen]

I am trying to add conditional formatting to a group of cells with text. The formatting is based upon a formula that uses cell values(numbers) from elsewhere in the sheet. The formula is calculating whether a dynamic value is in or out of a specified range. When I input a value the number will change and if it is out of range then I want the cells to turn red, and if they are in then I want them to turn green. I have attached a sample of what I am looking. I am looking for both VBA and non VBA answers. I will end up needing this to be a macro.

Sean