Need a simple formula

[No]

I don't know Excel well, can someone help me out with this formula.

In col A I want any number under X or over X to show up in red

In col B I want any number over X to show up in red.



X= any number I can add in later

Thanks in advance