color value

[geoffhep]

can I assign a color value from the "R,G,B" chart to a cell.

eg; if I have a series of numbers from say 1 to 25 and each number has a value from either
of the three groups can i automatically have those cells filled by the appropriate color.

Thanks,
Geoff.

[protonLeah]

Have you looked at Conditional Formatting? It would require three formulas...but you didn't describe the three groups to be tested against.

[geoffhep]

Have you looked at Conditional Formatting? It would require three formulas...but you didn't describe the three groups to be tested against.

Thanks a lot for that it was right on the money. You saved me big time with that. saw it in the help file but did not understand it originally

on this same project I have about 4000 lines in columns I - M that I want to sort from right to left.lowest to highest. these are of a numerical value. Unfortunately all the help files I have read will only allow me to sort one row at a time. even when I use the multiple function "then"
it changes the following row based on the highest number of the previous row.

Any ideas on this? it's a lot of lines to change manually....

[protonLeah]

The below will sort one row at a time from left to right lowest to highest.

Please Login or Register  to view this content.