Conditional formatting in relation to other cells

[Guest]

Hi

I have a league table in which, dependant upon the position the month before
one of the cells in the row displays an up arrow or a down arrow or a "stay
the same" arrow. Using conditional formatting I can change the colour of the
arrow either green, red or black respectively. However is it possible to
change the rest of the row in relation to these arrow, to the same colour as
they're respective arrow?

 

[Guest]

You can set conditional formatting in each cell in the row based on the
condition that changed your arrow. As an example if rows 1-6 in column A
have random integers and you want to highlight the row from a-j for those
rows with 0 in column A, select the range a1..j6, under conditional
format|formula is:

=$A1=0

The absolute $A will set the condition for each column a-j on the evaluation
of the data contained in column A

Lance

 

[Guest]

I get ya, thanks very much.

You can set conditional formatting in each cell in the row based on the
condition that changed your arrow. As an example if rows 1-6 in column A
have random integers and you want to highlight the row from a-j for those
rows with 0 in column A, select the range a1..j6, under conditional
format|formula is:

=$A1=0

The absolute $A will set the condition for each column a-j on the evaluation
of the data contained in column A

Lance