All the cells of negative numbers will become red, while the positive numbers will remain the same. 2] Using custom formatting You can create your own custom format in Excel to highlight negative ...

Text to numbers Thanks for all the thoughts below. Much appreciated. I found a solution that works for negative and positive numbers, so it can be copied down a column. If the text is in C4, then in ...