conditional formatting excel 2002

[Joe1010]

I would like to add a conditional formatting (in excel 2002) for the entire line. The color of all columns should be changed based on the information in column G.
Is this possible without code?

Thanks

 

[kjv1611]

Please give a little more detail.

line? Do you mean Row or Column?

The color of all columns should be changed based on the information in column G.

So, I'm guessing here that you mean a whole row would be conditional formatting based on the column G?

If so, are you only looking at the one cell in column G that lines up with your one particular row?

Please give an example of the data you want to compare against as well..

--

"If to err is human, then I must be some kind of human!" -Me

 

[Joe1010]

If paid = Y the row should be green
Order# date customer amount Paid
123456 4/7/2008 Microsoft 520.33 Y
789456 4/7/2008 Excel 214.3 N

 

[kjv1611]

I think what you need may be along the lines of what I got some help with, except you're highlighting the whole row, whereas I was only highlighting one cell.

Take a look at this thread:
thread68-1360257

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

Hi,

When you assign the Formula is: textbox, make the COLUMN reference ABSOLUTE and the ROW reference RELATIVE, like...
[tt]
=$G2=CriteriaValue
[/tt]

Skip,

_[red][/red]

 

[Joe1010]

The link you gave me is more complicated formatting. I need a simple one line code.
If G1 = Y then A1, B1, C1, D1, E1, F1 should be green.
I select A1, B1, C1, D1, E1, F1, and then I go to conditional formatting, select Formula is, then what do I type.
Thanks

 

[SkipVought]

Select ALL your data range, like A1:G9999...
[tt]
Formula is: =$G1="Y"
[/tt]

Skip,

_[red][/red]

 

[kjv1611]

When I grow up, I wanna be just like Skip - able to answer a tall question in a single post!

--

"If to err is human, then I must be some kind of human!" -Me