excel condition

Copper Contributor

I'm having trouble inserting a condition in the excel cell. I have two columns with values, I would like for example, whenever the value in the cell of column A is greater than or equal to the cell in the column B, that the cell in the column A fills with a color. For example, If A1> = B1, fill in red.

3 Replies

@Rubia_Armini 

Select A1:A100, for example. A1 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

 

=AND(A1<>"",A1>=B1)

 

Click Format...

Activate the Fill tab.

Select red.

Click OK, then click OK again.

Thank you for answer me. I did exactaly as you said and didn't work (Incling doing CTRLc CTRLv of your formule). :\

@Rubia_Armini 

It should work:

S0454.png

Please attach a workbook that demonstrates the problem.