I need values in a chart to change colour depending on two values that are entered, preferably green and red.

I need each cell in the chart (light purple) to look at the length value (B3) and compare it to the first value in its row (feet) to see if it is TRUE (=>).
Then compare the value in the individual cell to the volume value (B5) to see if is TRUE (=>).

Depending on the results, turn the cell fill colour red (T,F; F,T or F,F) or green (T,T).

My thought was to use the IS function, but I don't know how to apply it to the whole chart other than doing each cell individually. My actual chart is mmuch bigger.

excel.jpg