Conditional Formatting Rows

[Newcombe]

I need to add a conditional format to multiple rows (i.e. format a2 if a1 = value, format b2 if b1 = value, etc.) but conditional formatting requires =$A$1 so I can't just drag the formatting across cells.

Any suggestions would be greatly appreciated!

 

[p45cal]

Ibut conditional formatting requires =$A$1 so I can't just drag the formatting across cells

No it doesn't, try $A1.

 

[T. Valko]

I need to add a conditional format to multiple rows (i.e. format a2 if a1 = value, format b2 if b1 = value, etc.) but conditional formatting requires =$A$1 so I can't just drag the formatting across cells.

Any suggestions would be greatly appreciated!

Select the entire range to be formatted, A2:B2

Conditional Formatting
Use the "formula" option
Enter this formula in that little box: =A1=10
Select the formatting you want then OK out.

Replace 10 with whatever value you want. If the value is TEXT then it must be quoted:

=A1="Yes"

 

[Newcombe]

Select the entire range to be formatted, A2:B2

Conditional Formatting
Use the "formula" option
Enter this formula in that little box: =A1=10
Select the formatting you want then OK out.

Replace 10 with whatever value you want. If the value is TEXT then it must be quoted:

=A1="Yes"

OH!! That was so close! It said it can't use relative references for colour scales, data bars or icon sets

(I'm starting to think I'm really SOL and may have to do each cell by hand...)

 

[T. Valko]

OH!! That was so close! It said it can't use relative references for colour scales, data bars or icon sets

(I'm starting to think I'm really SOL and may have to do each cell by hand...)

I never use that type of formatting so I don't know what else to suggest.

 

[ed53511]

This link with its link to samples proved helpful to me and may be helpful in solving your question.

http://www.contextures.com/xlCondFormat02.html

scroll down to

Download a zipped sample file for this Excel tutorial.

He also has many more resources

http://www.contextures.com/index.html

I hope this helps.