Conditional Formatting to Highlight Entire Row

[nirvehex]

Hi, I'm trying to figure out a way to highlight an entire row green if the value in column AY=1020.

Any idea how to use conditional formatting to do this? Or another easier way?

Thanks!

 

[cnestg8r]

1 B C D E G
2 765 667 101 829 417
3 12 899 264 495
4 964 195 280 487
5 238 171 966 490
6 138 860 620 496
7 473 267 586 417
8 748 103 463 732
9 286 232 463 79

Conditional Format
Formula: =$E2=$G$2
Applies to: =$B$2:$E$9

This highlights row 7.

 

[cnestg8r]

Book1
	A	B	C	D	E	F	G
1	1	B	C	D	E		G
2	2	765	667	101	829		417
3	3	12	899	264	495
4	4	964	195	280	487
5	5	238	171	966	490
6	6	138	860	620	496
7	7	473	267	586	417
8	8	748	103	463	732
9	9	286	232	463	79
10
11		Conditional Format
12		Formula: =$e2=$G$2
13		Applies to: =$B$2:$E$9
Sheet1

This highlights row 7

 

[nirvehex]

Thanks cnestg8r - I get the gist of this. Which option do I select under Conditional Formatting though? When I go to "Use a formula to determine which cells to format" I only see a box for one formula and not an "applies to" box. What am I missing?

 

[cnestg8r]

Use formula and then choose your method of highlighting. You can "Bold" the font, change the font size or color, fill the the background color...

 

[nirvehex]

I go to Conditional formatting -> New rule -> use a formula to determine which cells to format.

In the formula box I type =$AY=1020 (for any row where the value in column AY=1020, I want to highlight the row green.

Format I select fill = green.

This isn't working, but I'm not sure what I'm doing wrong.

 

[Fluff]

What is the range of cells you want this to work on?

 

[cnestg8r]

Fluff is right. In the dialog where you set the formula, make sure "applies to" includes the entire array. Rows and columns.

 

[romeumc]

I go to Conditional formatting -> New rule -> use a formula to determine which cells to format.

In the formula box I type =$AY=1020 (for any row where the value in column AY=1020, I want to highlight the row green.

Format I select fill = green.

This isn't working, but I'm not sure what I'm doing wrong.

Change the formula to =$AY1=1020

 

[cnestg8r]

If there is one header row, the data starts in AY2. Therfore you need $AY2=1020. Note that you still need to include all columns of the matrix in the range.