Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change background color
I am a new excel user. I will like to change the back ground of several
columns in a spreadsheet if the value of a cell falls below a certain number. Is this possible? I think VBA might be the way to go but I only know how to do this in access. Please help... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change background color
Select the cells you wish to format and then click FORMAT in the menu and
select CONDITIONAL FORMATTING. State your criteria and then click the FORMAT command button to change the backgroup color of the selected cells if the criteria is met. -- Kevin Backmann "chris" wrote: I am a new excel user. I will like to change the back ground of several columns in a spreadsheet if the value of a cell falls below a certain number. Is this possible? I think VBA might be the way to go but I only know how to do this in access. Please help... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change background color
No need for VBA. Try Format | Conditional Formatting
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "chris" wrote in message ... I am a new excel user. I will like to change the back ground of several columns in a spreadsheet if the value of a cell falls below a certain number. Is this possible? I think VBA might be the way to go but I only know how to do this in access. Please help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the background color of margins or headers? | Excel Discussion (Misc queries) | |||
Change Cell background color by selection | Excel Worksheet Functions | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
Change the border color used by Change Tracking | Excel Discussion (Misc queries) | |||
How Do I change the background color of a cell in microsoft excel. | Excel Discussion (Misc queries) |