I am trying to make a guide for my dragons on a game I play but I'm not quite sure how to code what I am trying to do.Linkex. if has values Guardian(C2:C100) and Dragoness(I2:I100) in its row then find which number its Length(F2:F100) is closest to according to 8.97(#cc0000), 11.57(#b30080), 14.17(#9900ff), 16.76(#834ff5), 19.36(#6d9eeb) coloring the cell accordingly.Kinda like what conditional formatting's color scale does._Edit__________________________________________________________________________>>Link to my explanation<<
Coloring cells according to the value to which its content is closest
google spreadsheets;conditional formatting