Hello,
I have two columns. If the right column is greater than the left column, i want it to show green, and if it's less, i want it to show red. Is there a way to drag this conditional formatting formula down so it applies to all rows without having to do the conditional formatting for each row one by one? I hope this makes sense.
Attached is sample data:
Book1.xlsx
Any help is greatly appreciated! Cheers!
Bookmarks