HomeОбразованиеRelated VideosMore From: Dinesh Kumar Takyar

Highlighting Excel cells while entering data

93 ratings | 15978 views
You can easily highlight MS Excel worksheet cells while entering data using Excel VBA. For many people this can be a useful tool to avoid incorrect entries. For color codes you can view this website: http://dmcritchie.mvps.org/excel/colors.htm For many more interesting videos you can visit: http://www.familycomputerclub.com For some more details on this specific video please visit: http://www.familycomputerclub.com/highlight-excel-cells.html If you wish you can subscribe to my channel and be notified whenever a new video is uploaded.
Html code for embedding videos on your blog
Text Comments (30)
kurban ali (4 months ago)
Hi sir good morning Is it possible to highlight the active cell in all Excel files permanently. Means if I will open a new workbook in that also it will applicable.
Ali Hassan (1 month ago)
+Dinesh Kumar Takyar can you plz elaborate how to do that
Ali Hassan (1 month ago)
can you plz elaborate how i can do that
Dinesh Kumar Takyar (4 months ago)
You can use the workbooks,open method like so: Workbooks.Open = Range("A1")
Sir is there any code to fill any formula in cell "c8" of many sheets
sandeep kumar (1 year ago)
thanks for this vidoe
Trupti Patel (1 year ago)
i am not able to save that, what am I doing wrong, I get it to work, but when I close my workbook and reopen next day it dosent save
Dinesh Kumar Takyar (1 year ago)
You have to save the file as a macro-enabled file with the extension ".xlsm" .
Julia L (1 year ago)
is there any way to make the active (selected) cell transparent (clear of any color). I have a dark image for the background and i wanna keep seeing that image even when i have a cell selected.
NRHTX (1 year ago)
Awesome script, how do you run this script all the time?
P. BHAISWAR (1 year ago)
Sir, the code you have made is amazing! But only one problem with the worksheet here that If I have have colored some cells in the worksheets.....so all the cells become white after using this code......so the cells I have colored should be kept as it is. So please modify this code in that way so that it will be helpful for all.........thanks sir
Rob Roy (1 year ago)
I agree with PRITI. I like how the active cell gives me the ability to track the current cell I am in, but I can not fill other cells with a different color. The color is removed the moment I click out of the cell. I followed your instructions to the "T" on a new worksheet and still had the same result.
P. BHAISWAR (1 year ago)
Sir, actually I do not know much about vba code.....only I use the code you made.....So please have the code as I mentioned earlier.....please sir
Dinesh Kumar Takyar (1 year ago)
What have you tried? Change the code so that only the cell in which you are working changes the color. If you don't find the solution let me know. Tip: The cell in which you're working is called 'ActiveCell'.
Ashutosh Verma (2 years ago)
hii..Before putting dis command I had some color cells in my data but they got white after dis command . Now wat should I do? pls reply asap!
G. Lopez (2 years ago)
how do I make it to where I won't be entering the formula every time I open the excel sheet
Ali Hassan (1 month ago)
same question
Owaisecool Mohmmed (2 years ago)
Dear Dinesh Sir,With immense pride I must say that your videos are very very useful and helpful in my day today life,  the solutioning was awesome...Right now I am kind of stuck and I need your help, below is the my request and need your help...I have one Excel file which has 2 sheets one with series of texts and another with multiple textsFirst sheet :I got texts as TOMHANKSTIMPETERSecond sheet:I got ....TOM    HANKS    TOM  TIMHANKS  TIM     PETER TOMTIM   PETER  TOM HANKSWhat I need :When ever I click on Tom in first sheet it should go to second sheet and highlight Tom where ever in the cell should highlighted, similarly for TIM .. meaning every time when I click on the cell value in the first sheet the second sheet should highlight or color the value that I clicked on first sheet....please let me know how do I need to do this... apparently once you have the solution for this request you to kindly email me the link in [email protected],Owaise
sayitwithplaid (3 years ago)
Dadisetty has a good point. I see the relevance of highlighting an otherwise non color sheet per the original request. But that extra bit that Dadisetty is looking for becomes relevant when fill colors are used to make the sheet easier to read or for reports. Perhaps formatting could be done when a report is printed but the fill can be an added plus when viewed on screen.
Dadisetty laxmi govind (3 years ago)
other cell colors are vanished when we are using this macro
Dadisetty laxmi govind (3 years ago)
sir please create a macro,so we can use other format colors also
Dinesh Kumar Takyar (3 years ago)
+Dadisetty laxmi govind The user just wants to highlight the cell in which he is entering data - most probably to make the data entry easier due to visual disability.  http://www.exceltrainingvideos.com/highlight-excel-cells-while-entering-data/
John Lew (4 years ago)
Thanks for the video, I'm wondering if you can highlight the active cell using conditional formatting? 
Dinesh Kumar Takyar (4 years ago)
+John Lew Have a look at this link:@conditional-formatting-solution/You can also search my websitehttp://www.exceltrainingvideos.comand you'll find at least 5 more conditional formatting solutions with and without VBA.
Eman A. (4 years ago)
i have a question, how do you enable "undo" button when you apply VBA?
Qamar Iqbal (2 years ago)
Delete the Macro.....
9mmbindsniper (5 years ago)
Thank you for your quick replyI will review the suggested vid, Just noticed that all the other formatting on other sheets is gone except for cond formatting. Really enjoy your vids and app your taking the time to make them
Dinesh Kumar Takyar (5 years ago)
Have a look at the video: Run VBA code on protected sheet. youtu-dot-be/wv1AgZR9G2c Replace '-dot-' with '.'
9mmbindsniper (5 years ago)
Just what I was looking for -HOWEVER When I *protect the sheet I get an ERROR and the following line of code is highlighted. (sheet protected, Data entry fields unprotected) "ActiveSheet.Cells.Interior.ColorIndex = xlNone" Thank you for any help.
ducksaj (6 years ago)
Very good, congratulations

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.