I am using a formula in conditional formatting to look at as cell and determine whether it is true or false.
My true false formula works. It simply looks at previous week and currents week data. If its the same, true, not the same, it's false.
I have verified the cell contents as true, and the conditional formatting formula will insert blue text bold letter. It should only do that when it is FALSE!
Here is the formula that I am using in conditional formatting:
Applies to : =$D$10:$D$150
The $BG column is where I am looking on another sheet, starting at row 10. There are approximately 130 rows of data.
Do I not have something set right with the formula to look at the range of cells, i.e., BG10:BG130...???