How do I Highlight a row, where something is found?

G

Guest

I am trying to highlight an enitire row when a column in the row contains
certain text. I can get it to highlight the box that it is in but I would
like to highlight the whole row if possible.
 
D

David Biddulph

You haven't told us what conditional format formula you are using, but try
something of the form Formula is =$A1="wanted text".
(Absolute reference for the column, relative reference for the row).
 
V

vezerid

Select ALL columns of your data (or even the entire sheet). Assuming
your test column is C:C and you selected from row 1.

Conditional Formatting, Formula Is:

=$C1="my choice"

HTH
Kostis Vezerides
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AUTOMATIC HIGHLIGHT 1
Excel Typed text appears in wrong cell 0
Highlight a row when certain data is entered 4
Creating a formula to highlight a row of cells 3
If this cell is highlighted, then also highlight these cells 1
Highlight more than one entire row when cells = TRUE 5
How do I highlight a row in Excel based on the current time? 2
Formula Help 9

Top