Reply to thread

Message: [QUOTE="Glyn, post: 3786860"] I have a budget on one sheet and actual on another sheet. When the actual exceeds the budget I want to have a background color of red and when the actual is less than or equal to the budget I want the selected range to be green. I cannot get the background color to change under any codition. I have selected a range and clicked on the pain icon and selected a color but nothing happens to the selected range. Is there some setting in the workbook that is preventing the change. Thanks, [/QUOTE]