Row Formatting

H3MSY · May 14th, 2002, 08:47 AM

I am trying to do the following:-

Row A contains values 3,4,5,2,3,4,2,1 for example

If there is a certain value in that row, say 5, I want the whole row to turn yellow.

Conditional formatting seems to just work on the cell.

Can anyone help.
Is it possible in code

Audiojoe · May 14th, 2002, 08:50 AM

http://www.mrexcel.com/index.html#tow

Check this out, just below the part about Gantt

Audiojoe

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 08:47 AM	#1
H3MSY Board Regular Join Date: Apr 2002 Location: ENGLAND Posts: 62	I am trying to do the following:- Row A contains values 3,4,5,2,3,4,2,1 for example If there is a certain value in that row, say 5, I want the whole row to turn yellow. Conditional formatting seems to just work on the cell. Can anyone help. Is it possible in code

May 14th, 2002, 08:50 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	http://www.mrexcel.com/index.html#tow Check this out, just below the part about Gantt Audiojoe