xrajncajnx
New Member
- Joined
- Jun 24, 2014
- Messages
- 8
I'm trying to create a very simple conditional formatting and for some reason Excel refuses to highlight all the cells. I have a block of cells A1:B4, in the lower left hand cell is a percentage. If the percentage is greater than 0% I want the entire block of cells to highlight blue. Once created, I would like to copy that formatting to additional blocks of cells with the same setup. My current rule setup:
Rule: =A3>0
Format: Blue
Applies to: =$A$1:$B$3
The problem I am having I that it will only highlight the cells if there is text in the cell directly below it. So, if A2 has text, then A1 will highlight. But B2 is blank, so B1 will not highlight. However, if I change my rule to read =$A$3>0, then the conditional formatting works fine. The issue with that is every time I copy & paste that formatting it will refer to cell A3 rather than the lower left of each block. I've check to make sure it's not an issue with that specific spreadsheet by starting one clean, so I know it's not a current formatting issue.
Rule: =A3>0
Format: Blue
Applies to: =$A$1:$B$3
The problem I am having I that it will only highlight the cells if there is text in the cell directly below it. So, if A2 has text, then A1 will highlight. But B2 is blank, so B1 will not highlight. However, if I change my rule to read =$A$3>0, then the conditional formatting works fine. The issue with that is every time I copy & paste that formatting it will refer to cell A3 rather than the lower left of each block. I've check to make sure it's not an issue with that specific spreadsheet by starting one clean, so I know it's not a current formatting issue.
