I want to create a macro that will change the cell color if a number (any) is entered in that cell. For example, the cell color would change from yellow to white. Any suggestions or help would be very much appreciated
I want to create a macro that will change the cell color if a number (any) is entered in that cell. For example, the cell color would change from yellow to white. Any suggestions or help would be very much appreciated
Have you looked at excel native conditional formatting?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clicking below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
no, but I will have a look
Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks