SOLVED

changing cell total colour

%3CLINGO-SUB%20id%3D%22lingo-sub-1478787%22%20slang%3D%22en-US%22%3Echanging%20cell%20total%20colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478787%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all.%20Im%20fairly%20new%20to%20Excel.%20In%20my%20document%20i%20have%20a%20cell%20that%20totals%20a%20minus%20sum%20(e.g%20%24-200.00)%3C%2FP%3E%3CP%3EI%20would%20like%20the%20colour%20of%20that%20sum%20to%20be%20colour%20red%20automatically%20and%20then%20turn%20back%20to%20black%20when%20it%20becomes%20a%20plus%20amount%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20some%20way%20of%20telling%20Excel%20to%20do%20this%26nbsp%3B%20for%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1478787%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478847%22%20slang%3D%22en-US%22%3ERe%3A%20changing%20cell%20total%20colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478847%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F705571%22%20target%3D%22_blank%22%3E%40cuckooca%3C%2FA%3E%26nbsp%3BUse%20Conditional%20Formatting.%20Select%20the%20range%20of%20cells%20where%20they%20may%20be%20negative%2C%20click%20Conditional%20Formatting%20on%20the%20ribbon%2FHighlight%20cell%20ruls%2FLess%20than%200%20and%20choose%20the%20Fill%20and%2For%20Font%20color%20as%20you%20wish%20(you%20can%20take%20their%20defaut%20Light%20Red%20Fill%20with%20Dark%20Red%20Text%20font).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478862%22%20slang%3D%22en-US%22%3ERe%3A%20changing%20cell%20total%20colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478862%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675276%22%20target%3D%22_blank%22%3E%40hynguyen%3C%2FA%3E%26nbsp%3B%20Thank%20you%20so%20much%20.%20That%20did%20the%20trick.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1478886%22%20slang%3D%22en-US%22%3ERe%3A%20changing%20cell%20total%20colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1478886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F705571%22%20target%3D%22_blank%22%3E%40cuckooca%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20is%20custom%20number%20format%20as%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20496px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199898iA6B929C29A88D1BA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

3 Replies
Highlighted
Best Response confirmed by cuckooca (New Contributor)
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). 

Highlighted

@hynguyen  Thank you so much . That did the trick.

Highlighted

@cuckooca 

As variant is custom number format as

image.png