is it possible to get excel to set the cell background colour programtically??
basically i want to do a logic function (i can do all the logic functions) on a cell and if it is ture set the background colour to red for example and if it is false set it to green for example.
is this possible with excel??
i am using office 200 BTW if that makes any odds.