| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formating Cells in Excel
Can I format a cell to automatically show a value in red if the value is a
negative %? |
|
#2
|
|||
|
|||
|
Sure, go to Format-Cells-Number and paste this format in the custom type:
0%;[Red]-0% Regards, A "David" wrote: Can I format a cell to automatically show a value in red if the value is a negative %? |
|
#3
|
|||
|
|||
|
yes- go to Format and select Conditional Formatting. It works like a formula
box with IF (cell) is equal/greater/less than than XXXX, then (insert format result- like Font Red) "David" wrote: Can I format a cell to automatically show a value in red if the value is a negative %? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
| How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
| Excel cannot shift nonblank cells | Excel Discussion (Misc queries) | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
| How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
Linear Mode
