Thread
:
How do i get excel to format a cell for a negative result.
View Single Post
#
5
Kassie
Posts: n/a
Hi Cisco,
Thanks for the response. It was a great pleasure!
--
ve_2nd_at. Randburg, Gauteng, South Africa
"Cisco" wrote:
Thanks Kassie,
can't believe it was so easy. Thought i need an "if" formula.
thanks
"Kassie" wrote:
Hi Cisco
Select the range where you want this t apply, click on Format|Cells, and
under the Numbers Tab, choose the type you want. You'll see that you can
select either positive or negative as red, and also as black
--
ve_2nd_at. Randburg, Gauteng, South Africa
"Cisco" wrote:
Hi,
Can someone please tell me how i can get excel to format the cell when the
result is negative.
eg 2 - 3 = -1 therefore the cell would turn red.
Reply With Quote