Home |
Search |
Today's Posts |
#1
|
|||
|
|||
color of a cell within a nested if function
is there a way to assign the color of a cell based on the value of another
cell within a nested if function? eg something like this formula in cell D350: IF(D351<0.5,color of cell N353,IF(D351<0.7, color of cell N364, color of cell N365)) i thinking some kind of conditional formatting maybe? thanks Ian |
#2
|
|||
|
|||
-- HTH RP (remove nothere from the email address if mailing direct) "Ian" wrote in message ... is there a way to assign the color of a cell based on the value of another cell within a nested if function? eg something like this formula in cell D350: IF(D351<0.5,color of cell N353,IF(D351<0.7, color of cell N364, color of cell N365)) i thinking some kind of conditional formatting maybe? thanks Ian |
#3
|
|||
|
|||
You need conditional formatting for this. Look up
'Highlight cells that meet specific conditions' in the Answer wizard in help -- HTH RP (remove nothere from the email address if mailing direct) "Ian" wrote in message ... is there a way to assign the color of a cell based on the value of another cell within a nested if function? eg something like this formula in cell D350: IF(D351<0.5,color of cell N353,IF(D351<0.7, color of cell N364, color of cell N365)) i thinking some kind of conditional formatting maybe? thanks Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Hiding a function value in a cell until function used | Excel Worksheet Functions | |||
Function to return colour of formatted cell | Excel Worksheet Functions |