HELP - conditional formatting???

[HeRoseInThree]

I have data that totals values for me, however I do not want or need the total information. Is there a way to search if b:b has "*total" that it changes the color of the text (conditional formatting) to white for the rest of the row?

Thanks in advance!

 

[Joe4]

Sure. Select all the rows you want to apply this to, and use the following Conditional Formatting formula:

=RIGHT($B1,5)="total"

and then select your white font color.

Note, when you write the equation, you always right it according to the first cell in your selection. Excel will automatically adjust it for all the others.
So, if you are starting your row selection on row 2, you would use $B2, not $B1.
The "$" is an absolute range reference, telling Excel to "freeze" the column reference at "B", so all cells will look at column B as you move across the row.
By not putting the absolute reference in front of the row reference, it allows that to move as you move down columns to other rows.

 

[HeRoseInThree]

You are AWESOME! Thanks!!!!!!!

 

[Joe4]

You are welcome!

Glad I was able to help.

Here is a nice little write-up on the different kinds or range references (absolute, relative, mixed): http://www.excel-easy.com/functions/cell-references.html

 

[HeRoseInThree]

I have another conditional formatting question.

If I filter some results out, can I highlight or otherwise separate every other row? I normally use =MOD(ROW(),2) but it wants to highlight every other row and not every other visible row...

 

[Joe4]

That gets a little complicated.
There are various solutions shown here: https://www.extendoffice.com/documents/excel/942-excel-shade-alternating-filtered-rows.html

 

[HeRoseInThree]

It does get a little tricky, but when the directions are step by step like that, even I can follow them!!! Thank you again!!!

 

[HeRoseInThree]

UPDATE:
I was able to use this on another project today!

THANKS again [MENTION]Joe4[/MENTION]