Excel - IF Function Problem - Expert Solution

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

I want to set the background color for my cells but don't know the right formula, for example If "processed" (color=green) or if "declined" (color =red)
Solved by V. J. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 01/03/2018 - 07:40
Welcome, Thanks for choosing Got It Pro-Excel
User 01/03/2018 - 07:40
Thanks for the help
Excelchat Expert 01/03/2018 - 07:41
you need to format the cells when it is processed be green
User 01/03/2018 - 07:42
Correct
User 01/03/2018 - 07:42
and if cell is declined then red
Excelchat Expert 01/03/2018 - 07:43
ok give me a moment
User 01/03/2018 - 07:43
Will do!
Excelchat Expert 01/03/2018 - 07:43
ok
Excelchat Expert 01/03/2018 - 07:46
like that you want it
User 01/03/2018 - 07:46
Yes indeed
Excelchat Expert 01/03/2018 - 07:46
now for do that
Excelchat Expert 01/03/2018 - 07:46
what excel version you use
User 01/03/2018 - 07:47
Excel 2016
Excelchat Expert 01/03/2018 - 07:47
to perform that
Excelchat Expert 01/03/2018 - 07:48
go to conditional formatting at home tab in style section
User 01/03/2018 - 07:48
Alright
Excelchat Expert 01/03/2018 - 07:48
then choose new rule
Excelchat Expert 01/03/2018 - 07:48
in new rule choose custom formula
User 01/03/2018 - 07:49
Alright what's the formula
Excelchat Expert 01/03/2018 - 07:49
ok lets assume that the range you want to be formatted is b2:b100
Excelchat Expert 01/03/2018 - 07:50
then the formula is
Excelchat Expert 01/03/2018 - 07:50
=b2="processed"
Excelchat Expert 01/03/2018 - 07:50
then select the background color from format
Excelchat Expert 01/03/2018 - 07:51
and add another rule and put this formula
Excelchat Expert 01/03/2018 - 07:51
=b2="declined"
Excelchat Expert 01/03/2018 - 07:51
are you get it
User 01/03/2018 - 07:52
I typed both in and hit enter but nothing happened affter
User 01/03/2018 - 07:53
I put both in
Excelchat Expert 01/03/2018 - 07:53
now go to manage rule
User 01/03/2018 - 07:53
I have a tally system already set as in =COUNTIF(D2:D100,"Declined")
User 01/03/2018 - 07:53
okay one moment
User 01/03/2018 - 07:54
Alright I am in the manage section
Excelchat Expert 01/03/2018 - 07:54
then on show formatting ruls for
User 01/03/2018 - 07:54
I see my 2 formulas
Excelchat Expert 01/03/2018 - 07:55
change the range applied
User 01/03/2018 - 07:55
It says Applies to
User 01/03/2018 - 07:55
-$D$2
User 01/03/2018 - 07:55
=$D$2
Excelchat Expert 01/03/2018 - 07:56
ok you want to apply this to range d2:
Excelchat Expert 01/03/2018 - 07:56
what is the column you want to apply this formatting to
User 01/03/2018 - 07:56
So in that box I need to type range d2: d100
Excelchat Expert 01/03/2018 - 07:57
yes and add $ sign
Excelchat Expert 01/03/2018 - 07:57
be $D$2:$D$100
User 01/03/2018 - 07:57
Where would I add the sign at d2$ D100
User 01/03/2018 - 07:57
okay
Excelchat Expert 01/03/2018 - 07:58
and formula must be
Excelchat Expert 01/03/2018 - 07:58
=d2="processed"
User 01/03/2018 - 07:58
alright
Excelchat Expert 01/03/2018 - 07:58
is it work
User 01/03/2018 - 07:59
So formula is set and so is range
Excelchat Expert 01/03/2018 - 07:59
yes to first cell in range
Excelchat Expert 01/03/2018 - 08:00
[Uploaded an Excel file]
Excelchat Expert 01/03/2018 - 08:00
like this
Excelchat Expert 01/03/2018 - 08:00
but change every b to d
User 01/03/2018 - 08:01
My format box says No format Set
Excelchat Expert 01/03/2018 - 08:02
are you see the picture I sent
User 01/03/2018 - 08:02
Yes correct
Excelchat Expert 01/03/2018 - 08:02
apply like it
User 01/03/2018 - 08:02
Your 2 boxes are colored as mine are white and says No format Set
User 01/03/2018 - 08:03
Wait I think I got it
Excelchat Expert 01/03/2018 - 08:03
ok in the rule where processed hit edit rule
User 01/03/2018 - 08:03
I formated both to the colors
Excelchat Expert 01/03/2018 - 08:03
good
Excelchat Expert 01/03/2018 - 08:03
are it work
User 01/03/2018 - 08:03
It worked :D
Excelchat Expert 01/03/2018 - 08:04
good
Excelchat Expert 01/03/2018 - 08:04
are you need any thing else
User 01/03/2018 - 08:04
That is all! I appreciate your assistance today.
Excelchat Expert 01/03/2018 - 08:04
you welcome
User 01/03/2018 - 08:04
Definitely A pro
User 01/03/2018 - 08:04
5 STAR *****
Excelchat Expert 01/03/2018 - 08:05
thak you
User 01/03/2018 - 08:05
My pleasure!
Excelchat Expert 01/03/2018 - 08:05
thank you
User 01/03/2018 - 08:05
If I have any questions in the future can I email you ?
User 01/03/2018 - 08:05
you seem to be quite expierenced
Excelchat Expert 01/03/2018 - 08:05
you welcome any time you want help
Excelchat Expert 01/03/2018 - 08:05
all our experts is ready to help you
User 01/03/2018 - 08:06
Alrighty, well you take it easy, god bless and have a wonderful day !
Excelchat Expert 01/03/2018 - 08:06
Have a good day ahead

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
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc