Dear experts,
we have a spreadsheet with sales forecasts and an OP who is entering the
real sales data month by month when available. I would like to be able to
make a difference between the forecast months and the real figures, possibly
with different cell colours and by protecting the real figures; to do so, I
would like Excel to recognize that the data in cell is entered by a
particular user - the OP - and therefore change format and protect the cells.

Is this possible with VBA programming?
Thank you!
Best regards
--
Valeria

Debra Dalglish has a sample Budget v Actual workbook you can download for free.
Workbook contains Budget & Actual worksheets which uses conditional
formatting to show when Actual figures have been entered. This, although may
be different from your workbook, should give you a good working example to
help meet your needs.

site link below & file needed in list

hope helpful

http://www.contextures.com/excelfiles.html

FN0005 - Budget vs Actual -- Enter budget and actual amounts; summary sheet
shows totals year to date; contains macros. zipped file; BudgetYTD.zip 26 kb

--
jb


"Valeria" wrote:

> Dear experts,
> we have a spreadsheet with sales forecasts and an OP who is entering the
> real sales data month by month when available. I would like to be able to
> make a difference between the forecast months and the real figures, possibly
> with different cell colours and by protecting the real figures; to do so, I
> would like Excel to recognize that the data in cell is entered by a
> particular user - the OP - and therefore change format and protect the cells.
>
> Is this possible with VBA programming?
> Thank you!
> Best regards
> --
> Valeria