cd_morris
asked on
Highlight cells
If there is a value in Column A. How can I hightlight (turn Red) all cells that are empty or has a value of 0 or less
You can use conditional formatting, but we'd need more information: which cells do you want to highlight based on which cell(s) in column A having a value?
ASKER
Can it be done with VBA?
ASKER
So while there is a value in column A, and if a cell in range B:I is either blank or has a value of ) or less, I want to turn it red
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.