change cells when a particular user makes her input

  • Thread starter Thread starter Valeria
  • Start date Start date
V

Valeria

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
 
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
 
Back
Top