Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting in relation to other cells
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? |
#2
|
|||
|
|||
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 "Mr Dummy" wrote: 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? |
#3
|
|||
|
|||
I get ya, thanks very much.
"LanceB" wrote: 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 "Mr Dummy" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting adjacent cells | Excel Worksheet Functions | |||
Cells losing formatting | Excel Discussion (Misc queries) |