Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change cell background based on multiple cells
This is what I'm trying, unsuccessfully, to do:
If the value of A1 is "Hourly" AND the value of C3 is <10, change the background to yellow If the value of A1 is "Salary" AND the value of C3 is 14, change the background to green I have been unable to do this using conditional formatting. Can someone help with VB? Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change cell background based on multiple cells
Formula is
=AND($A$1="Hourly",$C$3<10) 2nd condition =AND($A$1="Salary",$C$314) works for me -- Regards, Peo Sjoblom wrote in message ups.com... This is what I'm trying, unsuccessfully, to do: If the value of A1 is "Hourly" AND the value of C3 is <10, change the background to yellow If the value of A1 is "Salary" AND the value of C3 is 14, change the background to green I have been unable to do this using conditional formatting. Can someone help with VB? Thanks!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change cell background based on multiple cells
Thanks!
Now I'm having another problem with it. This is going to be part of a macro, and the number of rows may change with each worksheet. When I apply the formatting to the entire column, which includes a header row, the highlighed cells are shifted up one row because the header is included. So my question is, how can I exclude the header and have the correct cells highlighted? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto change background of color based on formula | Excel Worksheet Functions | |||
What is the macro to change background based on numeric cell value | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
Is it possible to change colors of cells based on value in cell (. | Excel Worksheet Functions |