ExcelBanter - Formating Cells in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formating Cells in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/37293-formating-cells-excel.html)

David

Formating Cells in Excel

Can I format a cell to automatically show a value in red if the value is a
negative %?

aristotle

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 %?

Christine

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 %?

All times are GMT +1. The time now is 10:42 AM.