Forum Discussion

cuckooca's avatar
cuckooca
Copper Contributor
Jun 20, 2020
Solved

changing cell total colour

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.

Formulas and Functions
  • hynguyen's avatar
    hynguyen
    Jun 20, 2020

    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). 

3 Replies

  • hynguyen's avatar
    hynguyen
    Iron Contributor
    Jun 20, 2020

    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). 

Resources