Hi sjp1966



For column A, Select column or range of cells > Conditional formatting > New Rule etc.

Condition 1. Greater then equal to C1: =AND($A1<>"",$A1>=$C1) Format as required.
Condition 2. Less the C1: =AND($A1<>"",$A1<$C1) Format as required.

Same for Column B adjust cell references as required

@sjp

Hi,
it's best to add a sample sheet instead of a picture so that we don't have to retype data.
Kevin has tackled this one without effort

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post