View Single Post
  #1   Report Post  
Ian
 
Posts: n/a
Default 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