SIR,
I AM USING EXCEL 2000, IS THERE ANY FORMULA THROUGH WHICH WE CAN GIVE AT TEXT OUTPUT IN CERTAIN FORMAT SUCH AS BLINK OR COLOUR CHANGING FORMAT.
SUPPOSE ANY DATA MISMATCH HAPPENS IN CERTAIN CELL THEN THE RESULTANT CELL WILL GIVE AN RED BLINKING TEXT. "ERROR"
You can use "Conditional Formating", just look for it on the help. It is a great tool and it is relatively easy to set, you can choose blinking red text when the condition occur, in your case mismatch.
I have excel 2007 but I know this function exists in 2000 as well. Let me know if you need more help and I will be happy to assist you
Yes of course, if you have a little background of visual basic programming that's possible you can enhance your requirements.
Please see link http://www.techonthenet.com/excel/questions/cond_format1.php
Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.
Press Back space on your keyboard. And
select Format as ASCII (comma delimited). Now give output File Name as
Daybook.csv, now select some other option you want to export from the
bottom of the screen.
Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,
Double click on it, the file will open
in excel program. If you want it in excel work sheet file, use the
option Saveas, and save it in Microsoft excel workbook (*.xls) format.
Hope this is helpful. Let us know if the issue is resolved.
*Rating and Comments are invited for this solution
170 views
Usually answered in minutes!
×