Jun 20 2020 10:07 AM
Hello all. Im fairly new to Excel. In my document i have a cell that totals a minus sum (e.g $-200.00)
I would like the colour of that sum to be colour red automatically and then turn back to black when it becomes a plus amount again.
Is there some way of telling Excel to do this for me.
Jun 20 2020 11:17 AM
Solution@cuckooca Use Conditional Formatting. Select the range of cells where they may be negative, click Conditional Formatting on the ribbon/Highlight cell ruls/Less than 0 and choose the Fill and/or Font color as you wish (you can take their defaut Light Red Fill with Dark Red Text font).
Jun 20 2020 11:34 AM
@hynguyen Thank you so much . That did the trick.
Jun 20 2020 12:00 PM
Jun 20 2020 11:17 AM
Solution@cuckooca Use Conditional Formatting. Select the range of cells where they may be negative, click Conditional Formatting on the ribbon/Highlight cell ruls/Less than 0 and choose the Fill and/or Font color as you wish (you can take their defaut Light Red Fill with Dark Red Text font).