Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Background Color for selected range
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, -- Glyn |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Background Color for selected range
for example your boundary is 100
first put the color u want when number is below or equal to 100 then go to conditional formatting, number rules, greater than, enter 100 there, and choose your color. this should work, it does in mine. "Glyn" wrote: 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, -- Glyn |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Background Color for selected range
I want the range to be green if B10<=B54. I went to Format/Conditional
Formatting/selected the color and on the dropdown selected Formula is and entered =B10<=B54, said ok and nothing happened. -- Glyn "Raz" wrote: for example your boundary is 100 first put the color u want when number is below or equal to 100 then go to conditional formatting, number rules, greater than, enter 100 there, and choose your color. this should work, it does in mine. "Glyn" wrote: 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, -- Glyn |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Background Color for selected range
Try with absolute references.
Select a range then FormatCFFormula is: =$B$10<=$B$54 Gord Dibben MS Excel MVP On Mon, 6 Oct 2008 12:18:05 -0700, Glyn wrote: I want the range to be green if B10<=B54. I went to Format/Conditional Formatting/selected the color and on the dropdown selected Formula is and entered =B10<=B54, said ok and nothing happened. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Background Color for selected range
Tried with absolute references to no avail. I cannot even change the cell
colors with the "Paint icon" -- Glyn "Gord Dibben" wrote: Try with absolute references. Select a range then FormatCFFormula is: =$B$10<=$B$54 Gord Dibben MS Excel MVP On Mon, 6 Oct 2008 12:18:05 -0700, Glyn wrote: I want the range to be green if B10<=B54. I went to Format/Conditional Formatting/selected the color and on the dropdown selected Formula is and entered =B10<=B54, said ok and nothing happened. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Background Color for selected range
After entering the formula is: did you click on FormatPatterns and pick a
color? Gord On Mon, 6 Oct 2008 17:50:05 -0700, Glyn wrote: Tried with absolute references to no avail. I cannot even change the cell colors with the "Paint icon" |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Background Color for selected range
Yes I did. I am beginning to think there is something wrong with my Excel
program or my computer. My son cand do the same thing on his computer as I am doing on mine and his works. I tried re-installing excel on my computer and that didn't help. -- Glyn "Gord Dibben" wrote: After entering the formula is: did you click on FormatPatterns and pick a color? Gord On Mon, 6 Oct 2008 17:50:05 -0700, Glyn wrote: Tried with absolute references to no avail. I cannot even change the cell colors with the "Paint icon" |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Background Color for selected range
If you wish, you could send the workbook to me personally.
Change the AT and DOT to get my email address. Gord On Tue, 7 Oct 2008 09:56:38 -0700, Glyn wrote: Yes I did. I am beginning to think there is something wrong with my Excel program or my computer. My son cand do the same thing on his computer as I am doing on mine and his works. I tried re-installing excel on my computer and that didn't help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change background color of highlighted Excel range ? | Excel Discussion (Misc queries) | |||
Changing the color of a selected range | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
How can you change the color of the selected range? | Excel Discussion (Misc queries) |