| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation for Effecting Pattern Color, Bold, Etc.
Could anyone provide me with the syntax for the following example:
If B1 0, turn the cell blue; if B1 <= 0, turn the cell red -and- If B1 0, make the font red; otherwise, leave as is. Are these possible? Thank you in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculation for Effecting Pattern Color, Bold, Etc.
check out conditinal formating in help
format-conditional format "Platypus" wrote: Could anyone provide me with the syntax for the following example: If B1 0, turn the cell blue; if B1 <= 0, turn the cell red -and- If B1 0, make the font red; otherwise, leave as is. Are these possible? Thank you in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculation for Effecting Pattern Color, Bold, Etc.
Conditional formating is the way to go with this. If you look into the
format-conditional formating, the dialog will allow you up to 3 conditions and allow you to change the cell color, borders, and font under the conditions you select. It is very simple to figure out. "bj" wrote: check out conditinal formating in help format-conditional format "Platypus" wrote: Could anyone provide me with the syntax for the following example: If B1 0, turn the cell blue; if B1 <= 0, turn the cell red -and- If B1 0, make the font red; otherwise, leave as is. Are these possible? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell pattern - color | Excel Discussion (Misc queries) | |||
| Date sensitive cell pattern color | Excel Worksheet Functions | |||
| How do you control the color/pattern of a pie chart? | Charts and Charting in Excel | |||
| Prefil Color Pattern in Excel | Excel Worksheet Functions | |||
| Pie Chart Color/Pattern | Charts and Charting in Excel | |||
Linear Mode
