VBA to compare cells on two different tabs

[gheyman]

I need to compare a template that was sent to the customer to the completed template that sent back. I cannot use the compare function that is an Ad-in because my users are not that savy.

is there a way, using VBA, to check to see if the return template has a "number" in cell D18. They should be entering in a dollar amount (Price). But sometime that add text like "No Bid" or NA..... I need to check that the cell is a number and if its not to flag the user that is comparing the response template before the data is pushed to a database.

I also need to check another cell to see if its a "whole number".

Thanks for the help.

Happy Holidays

 

[JGordon11]

Book1
	A	B	C
1	Is number?
2	FALSE
3	TRUE	1
4	TRUE	1.2
5	TRUE	26-Dec
6	TRUE	-5
7	FALSE	No Bid
8
9	Is integer?
10	FALSE
11	TRUE	1
12	FALSE	1.5
13	FALSE	12/26/2023 12:38
14	TRUE	12345678
15	TRUE	-5
16	FALSE	No Bid
17
Sheet3

Cell Formulas
Range	Formula
A2:A7	A2	=ISNUMBER(B2)
B13	B13	=NOW()
A10:A16	A10	=IF(ISNUMBER(B10), INT(B10)=B10)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A16	Expression	=A2=TRUE	text	NO
A2:A16	Expression	=(A2=FALSE)*(LEN(A2)>0)	text	NO