Can you put in anything so rest of row changes colour?

[Sara]

I have used conditional formatting in a certain coloumn so colour changes
depending on input I now need rest of row to change to same colour ??

 

[Don Guillett]

Either select the row first using the row number indicator at the left or
use the format painter.

 

[Bernard Liengme]

If I select row 1 to 10; and in Conditional Formatting specify
Formula Is $A1 =1 ; format with a red fill
then the entire row will be red is the cell in column A has value 1
hope this helps; best wishes

 

[Sara]

Sorry it's a bit more complicated the conditional formatting means that
depending on which date you enter the cell goes red, green or amber - it is
when the date is typed in and the cell chnages colour I want three other
cells on that row to change to that colour - the info in those cells will
already be typed in and does not relate to the colour.

 

[David Biddulph]

Use Formula Is, rather than Cell Value Is, and make appropriate choice of
Absolute and Relative addressing, for example Formula is =$A1=42.

 

[Don Guillett]

Use the format painter

 

[Sara]

Hi

I have looked at this but am unable to work it any ideas??

Thanks for your help.

Sara

 

[David Biddulph]

You're going to have to give us more information than that if you want us to
help you. What conditional formatting conditions do you have in which
cells, what data values do you have in the cells which affect the conditions
you are using, what formatting did it give you, and what did you expect?
Did you read the various replies to your earlier question, and did you try
them?

 

[Roger Govier]

Hi Sara

Supposing cell A1 is the cell with the date, and you want to test whether it
is equal to Today().
Supposing B1 is a cell where you set Conditional formatting
In B1 the Formula is =$A1=TODAY()
When 19/02/2008 is type in A1, your cell B1 will change to the require
colour.

Now, select B1>double click the Format painter (to make it sticky) then
click on cells D1, H1 etc and press Esc when you have finished.
Cells D1 and H1 will have the same Conditional formatting that you applied
to B1

This will only work, if you have made at least the column Absolute with $A1
not just A1

You can have three conditions applied to cell B1 to give your three colours
dependent upon the cell value, and provided you have "anchored" column A
with the absolute dollar, all three formats will be painted to any other
cell you choose.

 

[Sara]

Hi David

Yes I have tried the various replies but have not been able to work any of
them into my document.

Column C has dates written in and depending on the date it changes colour so
red for 10 days past, amber for 5 days past and green for any dates in the
future.

What I would like to do is when the date is typed in I not only want that
cell to change colour I also want four cells, A1, B1, C1(date), D1 to change
to the same colour as C1.

Does that make any more sense??

Thanks

Sara