ExcelBanter - View Single Post - fill color to a cell when the value is negative or positi

IanKR

temetua wrote in message
:

how do you color in a cell when its calculated value is negative is
negative or positive, say light red for negative and light green for
positive?
thx, musch appreciated

Select the cell(s) and choose Format | Conditional Formatting. Set up the
first condition for when the cell value greater than 0 and the second if it
is less than 0.