conditional format to highlight values out of range

Hi,
1. Can someone please help me to conditional format column F to highlight values that are out of range as defined in R2. Note WBC values are reported in 2 different format /L and mm^3.

2. Even sweeter if the same can be done for hemoglobin, platelet, and neutrophil count without having to convert the units first (uL to L)?

Thank you in advance.

Hi again,
I figured out the first part. Also noticed lots of values were incorrectly converted due to sloppy cut and paste. sorry :-)
I'll leave this thread open for a day more in case someone can offer a solution to the second part.

Thanks All.