Ive finally found my limit and need help.
I have a table of numbers both +'ve & -'ve that I want to translate to coloured cells on a second sheet,
ie black for greater than +/-250,
grey for -249 to -150 and 150 to 249
white for -149 to 149.
I know it can be done,but Im having big problems with the formula.
This must be chicken feed to someone.Any help would be appreciated.
I have a table of numbers both +'ve & -'ve that I want to translate to coloured cells on a second sheet,
ie black for greater than +/-250,
grey for -249 to -150 and 150 to 249
white for -149 to 149.
I know it can be done,but Im having big problems with the formula.
This must be chicken feed to someone.Any help would be appreciated.