**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.*