I would like to set conditional formatting where if value in one column is greater than another column.
I have included a sample table from what I'm working on. In this example table, I'd like conditional formatting to fill column C cell red if it is greater than column A.
I know how to do this for a single cell, but can't figure out how to set the whole column. I have over 7,000 cells in the column and definitely don't won't to do them 1 at a time or eyeball.
Appreciate your help,
Brian
Example_BRI.xlsx
Bookmarks