View Full Version : If cell = [Word], hilight row

03-27-2010, 05:52 PM
What i am wanting to do is this:
If A1 = [Word] then it will highlight the whole cell.
Would that be hard

03-27-2010, 06:00 PM
Select cell A1
Then, On the main toolbar select format

then select conditional format

Condition 1
first window.....second window.....third window
Cell value is......equal to .............="word"

03-27-2010, 06:06 PM
it only highlights the selected cell...

Cell value = word displays with yellow fill, but its only that 1 cell not the row

03-27-2010, 06:10 PM
select the cell.

hover over it's lower right hand corner and when you get an + left click and hold and drag it to whatever cells you want.

03-27-2010, 06:18 PM
You can also copy and paste the formatting

03-27-2010, 06:19 PM
Okay with that tho, there is going to be other text in the other cells that doesnt match the word, it is for a stat sheet

so one cell might be a name, the other cell a number etc.

03-27-2010, 06:22 PM
select each cell one at a time and treat it just as you did A1 except use the other text instead of




read the help file. You can use numbers and you can use formula's such as if the number is larger than or equal to etc.

03-27-2010, 06:22 PM
the thing is tho as it is a stat sheet, there could be 50 different names on that.
on the net someone said this, dunno if it helps.

Range("A" & Target.Row, Target.EntireRow)

03-27-2010, 06:30 PM
post an example of your data..

on one sheet show your data as it is and on another sheet format some of it the way you want it so we can look at it with you.

We are getting no where fast this way.

click the post reply button at the bottom left of the last post and then scroll down and look for a button that says manage attachments.

You've gone from asking about formatting one cell to using code for a row which is a little different.

remember, asking the right question is half of solving a problem and we can't see over your shoulder.