Hi

Mark cells E7:E60
DataValidationCustomFormula =AND($B$3="General Expenses,E7<=500)

--
Regards

Roger Govier


"Klee" wrote in message
...
I would like to use Data Validation to show a message if a cell
(E7:E60) is
more than $500 but I only want it to pop up if a different cell (b3)
says
"General Expenses".

If anyone can help it would be much appreciated
Thanks