software

I'm working on a spreadsheet that pulls data from separate sheets within
the same file. The data in the other sheets will be updated daily by
other users (each user will access the sheet, enter a date in 'their'
field, and then save/close the spreadsheet), and then totals from those
sheets will be displayed on the quot;mainquot; sheet, which I will then access
to finish my portion. Since the other users may forget to update their
portion on time each day, I'm trying to to find a way to change the
color of the text or display a warning that the fields on the other
sheets have not been updated on the current day.

For instance: Sheet A is my 'master' sheet and has totals from Sheets B
amp; C. Sheets B amp; C are updated by other users. I'd like a note or color
change in the fields of Sheet A that warns me that the necessary fields
on the other sheets have not been updated on the current day.

I think this would be done through a Change Event...? However, I'm not
familiar at all with this feature, so can someone help me with this?--
telewats
------------------------------------------------------------------------
telewats's Profile: www.excelforum.com/member.php...oamp;userid=30270
View this thread: www.excelforum.com/showthread...hreadid=504536Hi telewats. On your master sheet, assuming that a user enters a date on
sheet C in A1, you could have this in a cell on your master sheet:
=if(TODAY()gt;C!A1,quot;Not updated yetquot;,quot;quot;). HTH
--
Sincerely, Michael Colvinquot;telewatsquot; wrote:

gt;
gt; I'm working on a spreadsheet that pulls data from separate sheets within
gt; the same file. The data in the other sheets will be updated daily by
gt; other users (each user will access the sheet, enter a date in 'their'
gt; field, and then save/close the spreadsheet), and then totals from those
gt; sheets will be displayed on the quot;mainquot; sheet, which I will then access
gt; to finish my portion. Since the other users may forget to update their
gt; portion on time each day, I'm trying to to find a way to change the
gt; color of the text or display a warning that the fields on the other
gt; sheets have not been updated on the current day.
gt;
gt; For instance: Sheet A is my 'master' sheet and has totals from Sheets B
gt; amp; C. Sheets B amp; C are updated by other users. I'd like a note or color
gt; change in the fields of Sheet A that warns me that the necessary fields
gt; on the other sheets have not been updated on the current day.
gt;
gt; I think this would be done through a Change Event...? However, I'm not
gt; familiar at all with this feature, so can someone help me with this?
gt;
gt;
gt; --
gt; telewats
gt; ------------------------------------------------------------------------
gt; telewats's Profile: www.excelforum.com/member.php...oamp;userid=30270
gt; View this thread: www.excelforum.com/showthread...hreadid=504536
gt;
gt;


I think this formula would work for me. Just one question, though. Can I
use multiple criteria with the IF function, and if so, how would I write
the formula for this?--
telewats
------------------------------------------------------------------------
telewats's Profile: www.excelforum.com/member.php...oamp;userid=30270
View this thread: www.excelforum.com/showthread...hreadid=504536