software

I'm attempting to create a spreadsheet in Excel 2002 that records forecast
and actual data.

What I want to do is have forecast data for the period April to March in Row
1 and in another row (i.e. Row 5) record at the end of each month the actual
data for that month. Once the actual data for a month has been recorded I
want excel to turn the corresponding forecast figure for that particular
month to £0.00.

I've tried using conditional formatting but am unsure if this is possible.

Can anyone help?

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...excel/200601/1


Hi,
I may have misunderstood, but does this help...

Put your forecast figures in row 1 as normal amp; in row 2 (you may want
to insert another row) type quot;=if(A5lt;gt;0,0,a1)quot; amp; format the cell for
pounds.Hth,
Rob Brockett
NZ
I'm still learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=500074Thanks Rob

That help to solve the problem.

Happy learning!broro183 wrote:
gt;Hi,
gt;I may have misunderstood, but does this help...
gt;
gt;Put your forecast figures in row 1 as normal amp; in row 2 (you may want
gt;to insert another row) type quot;=if(A5lt;gt;0,0,a1)quot; amp; format the cell for
gt;pounds.
gt;
gt;Hth,
gt;Rob Brockett
gt;NZ
gt;I'm still learning amp; the best way to learn is to experience...
gt;

--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...excel/200601/1


That's cool - Happy learning to you too
:-)
Rob Brockett--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=500074