Excel Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1977077%22%20slang%3D%22en-US%22%3EExcel%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1977077%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20get%20Excel%20to%20turn%20the%20font%20red%20when%20there%20is%20a%20negative%20result%20to%20the%20formula%3F%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20any%20assistance.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1977077%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-1977151%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1977151%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F897933%22%20target%3D%22_blank%22%3E%40JoeT0672%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20the%20cell(s)%20with%20the%20formula.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20click%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3C%2FP%3E%0A%3CP%3ESelect%20'Format%20only%20cells%20that%20contain'.%3C%2FP%3E%0A%3CP%3ELeave%20the%20first%20drop-down%20set%20to%20the%20default%20'Cell%20Value'.%3C%2FP%3E%0A%3CP%3ESelect%20'less%20than'%20from%20the%20second%20drop-down.%3C%2FP%3E%0A%3CP%3EEnter%200%20in%20the%20box%20next%20to%20it.%3C%2FP%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3ESelect%20red%20as%20font%20color.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlternatively%2C%20you%20can%20specify%20that%20negative%20numbers%20should%20be%20red%20in%20the%20number%20format%20of%20the%20cells.%20No%20conditional%20formatting%20rule%20needed.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0026.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F239639i46D2313FB9EEAFAB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0026.png%22%20alt%3D%22S0026.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How do I get Excel to turn the font red when there is a negative result to the formula? 

Appreciate any assistance.  

1 Reply

@JoeT0672 

Select the cell(s) with the formula.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...

Select 'Format only cells that contain'.

Leave the first drop-down set to the default 'Cell Value'.

Select 'less than' from the second drop-down.

Enter 0 in the box next to it.

Click Format...

Select red as font color.

Click OK, then click OK again.

 

Alternatively, you can specify that negative numbers should be red in the number format of the cells. No conditional formatting rule needed.

 

S0026.png