MS excel conditional formatting
Posted on 2014-12-04
I have a data set that I used the sub-total function to sum a group of numbers. That works fine but, I want to change the font of the rows where the totals are. I use the conditional formatting function->new rule->use formula to determine which cells to format.
The column that I totaled is F and in the cell at the bottom of the grouping it say "1253 Total" and the rest of the row shows the summary of "1253" I use the formula =RIGHT($F1,5)="Total"
This usually highlights the a row but it's not always the right row, sometimes I need to adjust the formula to =RIGHT($F2,5)="Total or something like that until the right row is formatted. Can someone explain why the $F1 seems to be that way or is the a help video that I can't find out there?