| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
check cell
Hi snax500, One way to ensure input is to have a formula which highlights when the profit percentage hasn't been entered. This can be as "loud" as you choose (using red colour, bold, large font, etc) and disappears when the profit percentage is entered. eg If sales are entered in C3 and Profit percentage is entered in C4, then in say C5 you can enter: =IF(C3="","",IF(C4="","*** Please enter Profit percentage ***","")) Then format C5 with noticeable fonts. snax500 Wrote: Anyone have any ideas on how I can insure an input? -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=532758 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| cell calculation check if result is negative and zero out if not l | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| IF statement to check cell contents | Excel Worksheet Functions | |||
Threaded Mode
