| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to autoformat cell based on certain conditions
hi,
i have switched from excel xp to excel 2007. How to format the cell based on certain conditions. e.g. Brand % chg A 10.0 B -10.0 C 20.0 For % chg column, i want to highlight the whole cell in red if it is negative. Kindly advise. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to autoformat cell based on certain conditions
you can use conditonal formatting
-- Thanks Suleman Peerzade "Tiffany" wrote: hi, i have switched from excel xp to excel 2007. How to format the cell based on certain conditions. e.g. Brand % chg A 10.0 B -10.0 C 20.0 For % chg column, i want to highlight the whole cell in red if it is negative. Kindly advise. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a cell refrence another cell based on conditions? | Excel Worksheet Functions | |||
| Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
| Value of a cell based on three conditions | Excel Discussion (Misc queries) | |||
| Isolate and total cell values based on conditions | Excel Discussion (Misc queries) | |||
| Cell values based upon multiple conditions | New Users to Excel | |||
Linear Mode
