May 27 2021 07:49 AM
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.
May 27 2021 07:59 AM
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.
May 27 2021 08:36 AM
May 27 2021 11:13 AM