View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do I input these formulas into cells that I want written in?

You cannot put a formula into either A12 or G12 since this is where you want
to enter data.
I would use conditional formatting. Select A12 and open the Conditional
Formatting dialog; use the formula =AND(G1212, ISBLANK(A12) and set a
bright red fill colour.

For the $75 limit on G12 use Data Validation

If you need help with either topic, please return
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Paige" wrote in message
...
If an employee input a dollar amount into G12, can I mandate he fill in
what
the purpose was in A12? If he doesn't fill in the annotation in A12, then
he
has to remove the dollar amount in G12 before proceeding with the rest of
the
form. The highest dollar amount used in G12 would be $75.

Want dollar amount in G12
Want text in A12

I can make it work outside my cells with
Cell I formula
=IF(AND(G120,A12=""),"Error"," ")

Cell J formula
=IF(AND(G120,A12=""),"Need to fill out column A","OK")

How do I make it work inside my cells?