IF Formula to change cell color IF less than the value of another cell

[bemp87]

Hi Community - It's been a while since i've done this and it seemed to have slipped my mind on how to do it. I need a formula to fill a cell color if it is less or greater than another cell, for example:

IF(A1<B1"Fill Color Red")

Essentially i want cell A1 to fill color Red if it is less than the value in B1. I am needing to do this without using conditional formatting as this will be used for an entire row of cells and unless i'm doing something wrong, the conditional formatting gives me an error stating to apply it to a single cell...

Any guidance?

 

[bemp87]

Correction:

IF(A1 less than B1 then fill color red)<b1 "fill="" color="" red")<="" html=""></b1>

 

[Fluff]

You can do it with CF.
Select the range you want it to work on & use this formula
=$A1<$B1

 

[Fluff]

@MAIT
You either need to put a space after the < or "Go Advanced" & set HTML to "HTML Off"

 

[My Aswer Is This]

Conditional formatting can apple to a entire row or column
Do you mean you always want to compare Column A to Column B
Use this formula in conditional formatting in column A
Just select entire column A and then put this into conditional formatting rule:
=A1<b1< html=""></b1<>

 

[My Aswer Is This]

@MAIT
You either need to put a space after the < or "Go Advanced" & set HTML to "HTML Off"

Yes I have problems with this some times. Using MSEdge