PDA

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



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

lucas
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"

projectaero
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

lucas
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.

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

projectaero
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.

lucas
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

="word"

use

="otherword"

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.

projectaero
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)

lucas
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.