I would like to have all numbers in column D to be highlighted if greater than column F. I chose the entire column and selected "Greater Than..." within Conditional Formatting, but I only get the error: "You cannot use a direct reference to a worksheet range in a conditional formatting formula." Any special formula for doing this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting where one Column is greater than another
- Thread starter JadonR
- Start date
Similar threads
