Forum Discussion
Conditional Formatting
I'm having issues understanding conditional formatting. Here's a snippet of the data: 201-015000-1 201-012410-1 STM0877-01 STM0952-0101-17925 201-012419-1 STM0878-01 STM0882-01 ...
It looks like the rule looks at the cell below the one being formatted.
When you create the rule, make sure that the active cell in the selection is the first (top) cell in the selection.
And make sure that the formula refers to that cell.
For example, if the range is C1:C17, C1 should be the active cell in the selection, and the formula should be =ISNUMBER(FIND("201-",C1,1)) or alternatively =LEFT(C1,4)="201-"
Thanks, that fixed it. I noticed too, it was shifted, but the formula specified starting at C2, so I'm not sure why it didn't work. But, it's fixed and I can move on. Thanks so much.