Home » Forums » Open Source Learning Center » Question and Answer

Conditional Formatting in a Column

Submitted by Tindomerel on 17 January, 2016 - 04:58

I am using Excel 2007 on a Windows Vista Home Basic system. I am trying to format a column which contains a sum in which a cell is subtracted from another cell. I want the format of the cell to be red if the value is less than 0 and I want the format to remain black if the value is greater than 0. How can I do this?

‹ Find function inside a find function loop Comments: Changing text with VBA - Running into limitations ›
»

Hi Tindomerel, Assuming the

Submitted by mec1981 on 19 January, 2016 - 06:17.

Hi Tindomerel,

Assuming the sum starts in column C row 2, highlight C2 down to the last row that holds your sum formula. right click and select format cells, change from General to number, and select one of the red options for negative numbers i.e. either with or without the negative symbol present.

Alternately if you must use conditional formatting, highlight the same area - next click on conditional formatting - select new rule - select "use a formula to determine which cells to format"

Then under "Format values where this formula is true" put the following:
=If(C2<0,1,0)
then click on Format - from the colour drop down select red

Regards
Mark

»