Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

excel developer function Private Sub Worksheet_Calculate() Dim rg, cl As Range Set rg = Range("G13:G19") For Each cl In rg If cl.Value = "SUSPENSION" Then cl.Font.Color = vbRed Else: cl.Font.Color = vbBlack End If Next cl End Sub
Solved by C. B. in 58 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/12/2017 - 12:29
Thank you for choosing got it pro excel
Excelchat Expert 12/12/2017 - 12:29
How may I help you today?
User 12/12/2017 - 12:29
i need help with Excel developer
Excelchat Expert 12/12/2017 - 12:30
can you tell me more about that you specifically needed?
User 12/12/2017 - 12:32
how to make commands using the developer tab? e.g. design mode and visual basics tool. how do we script out what we want the database to do?
Excelchat Expert 12/12/2017 - 12:35
In the developer tab there is tab called insert where you can insert different commands they are mainly triggers to the vba codes
Excelchat Expert 12/12/2017 - 12:37
does that help you?
User 12/12/2017 - 12:37
what about the coding part? how do we code?
User 12/12/2017 - 12:37
is there any help online on coi
User 12/12/2017 - 12:38
Excelchat Expert 12/12/2017 - 12:39
do you have a file to share?
User 12/12/2017 - 12:40
i'm trying to create a database using these functions. currentlly trying to figure out how I am going to do this.
User 12/12/2017 - 12:41
i'm just stuck in the coding part under the visual basis tab
User 12/12/2017 - 12:41
I had a look at a sample database which used this function but I cannot understand the coding on it
Excelchat Expert 12/12/2017 - 12:43
ok, but what exactly are you trying to figure out?
User 12/12/2017 - 12:43
if there is any document available online for help?
Excelchat Expert 12/12/2017 - 12:44
apologies but we do not have an online courses for those scenario
Excelchat Expert 12/12/2017 - 12:45
if you can share what you are trying to program then we can find a way to help you out
User 12/12/2017 - 12:45
ok. thank you for your help.
Excelchat Expert 12/12/2017 - 12:45
I need more details to help you out
Excelchat Expert 12/12/2017 - 12:46
are you still with me?
User 12/12/2017 - 12:46
can I get your name?
User 12/12/2017 - 12:46
Excelchat Expert 12/12/2017 - 12:46
ok good
Excelchat Expert 12/12/2017 - 12:47
what I need to know is the specific program you would like to accomplish so we can start from there
User 12/12/2017 - 12:50
i have a database which I'm trying to amend in order to add more assets onto the database. this requires knowledge on the codes etc. I'm new to this so have no idea where to begin from.
User 12/12/2017 - 12:53
thanks for your help though
Excelchat Expert 12/12/2017 - 12:53
User 12/12/2017 - 12:53
i found a link. http://www.excel-easy.com/vba/create-a-macro.html
User 12/12/2017 - 12:53
this should help
User 12/12/2017 - 12:53
no problems
Excelchat Expert 12/12/2017 - 12:54
okay, I really want to help but for me to figure out the codes I should look into the files and should know the exact command that we will program to the developer \
Excelchat Expert 12/12/2017 - 12:54
I hope you will get what you needed from the link though
Excelchat Expert 12/12/2017 - 12:55
In case you have clarification just let me know
User 12/12/2017 - 12:56
i will..thanks
Excelchat Expert 12/12/2017 - 12:56
Excelchat Expert 12/12/2017 - 01:07
are you still with me?
Excelchat Expert 12/12/2017 - 01:11
Do you still need me to stay with you?
Excelchat Expert 12/12/2017 - 01:26
Since I haven't heard from you for a while so I am now ending this session, thank you for you time and for choosing Got it pro, hope to talk to you again.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc