| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change background colors based on criteria from another cel.
I need to use conditional formating on a group of cells where as a certain
point needs to reached in another cell for the condition to be true. Example: IF (B8<10), I need the background in (C12) to be blue, otherwise the background for the cell has no coding for a background color. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change background colors based on criteria from anothercel.
if cell B8 is less then 10, cell C12 to be colored as blue
if cell B8 is blank then also cell C12 to be colored ? Conditional format | condition 1 : formula is : =AND(B$8<10,B$8<"") | choose the color | ok On Feb 8, 11:50*pm, WavMaster wrote: I need to use conditional formating on a group of cells where as a certain point needs to reached in another cell for the condition to be true. Example: IF (B8<10), I need the background in (C12) to be blue, otherwise the background for the cell has no coding for a background color. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I change background colors based on criteria from anothercel.
On Feb 8, 9:50*pm, WavMaster
wrote: I need to use conditional formating on a group of cells where as a certain point needs to reached in another cell for the condition to be true. Example: IF (B8<10), I need the background in (C12) to be blue, otherwise the background for the cell has no coding for a background color. Have a look at the following link: http://www.contextures.com/xlCondFormat02.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change background color based on range value | New Users to Excel | |||
| Change background color based on value in column A | Excel Discussion (Misc queries) | |||
| Change background & foreground colors in Comment box | Excel Discussion (Misc queries) | |||
| Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
| How do I change background colors between secondary y axis lines? | Charts and Charting in Excel | |||
Hybrid Mode
