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.