Forum Discussion
excel condition
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
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). 😕
