#1
|
|||
|
|||
excel functions
WORKBOOK 1.xlsx WORKBOOK 2.xlsx Hi, I am new to this forum and my knowledge of excel is very basic. I have to workbooks. I wish to enter a date in a cell in workbook (2) but if it does not match the date in a nominated cell in Workbook (1) I require it to return an error message in workbook (2 ). Can this be done? |
#2
|
|||
|
|||
You can try
Copy both workbooks in the same folder, eg C:\test Open Workbook2 and add two extra columns that you can hide Set two VLOOKUP formula (see attach) In the B and C column set two conditions for Conditional Formatting, if the condition does not match paint it red font |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
implementing integral & gamma functions in excel | pid3control | Excel | 0 | 05-05-2015 01:10 PM |
Logical Functions - IF, AND, OR | juhikothari | Excel | 1 | 04-24-2015 12:39 AM |
Excel 2010 Functions | cmf10 | Excel | 6 | 07-02-2014 08:26 AM |
Assign functions to F1, etc. | ibclare | Office | 4 | 06-02-2011 03:22 PM |
** Using Functions | djreyrey | Excel Programming | 10 | 02-08-2011 04:18 PM |