Excel - IF Function Problem - Expert Solution

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

I'm looking to make it so that if A2="Name" then it will turn D2,E2,F2, and G2 red as a rule and apply it to my table
Solved by T. C. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 19/07/2018 - 07:22
Helo
Excelchat Expert 19/07/2018 - 07:22
Hello
User 19/07/2018 - 07:22
hi
Excelchat Expert 19/07/2018 - 07:23
I think you need a conditional formate
Excelchat Expert 19/07/2018 - 07:23
format*
User 19/07/2018 - 07:24
possibly, i've made a rule to highlights the box with name but i cant tell it to select different boxes
Excelchat Expert 19/07/2018 - 07:25
Just change the applied range.
Excelchat Expert 19/07/2018 - 07:25
Can I see the sheet you working with.
User 19/07/2018 - 07:25
=\$A\$2:\$A\$36="Name", Format \$D\$2:\$H\$2
Excelchat Expert 19/07/2018 - 07:25
Or you can fill a sample at the preview.
User 19/07/2018 - 07:26
i dont see rules
Excelchat Expert 19/07/2018 - 07:27
What rules ??
User 19/07/2018 - 07:27
conditional formatting
User 19/07/2018 - 07:27
new rule
User 19/07/2018 - 07:29
i'm not sure why other boxes are going red
Excelchat Expert 19/07/2018 - 07:29
I put a conditional format for the other boxes
Excelchat Expert 19/07/2018 - 07:30
As you described your problem, you need the boxes at D to H to turn red if A contain Name. Right ??
User 19/07/2018 - 07:31
yes
Excelchat Expert 19/07/2018 - 07:31
I make the conditional format for the cells D to H
User 19/07/2018 - 07:32
ok
Excelchat Expert 19/07/2018 - 07:32
Got it ??
User 19/07/2018 - 07:32
where are you setting that condition
Excelchat Expert 19/07/2018 - 07:33
select the columns D to H and right click then conditional format
User 19/07/2018 - 07:34
ok
User 19/07/2018 - 07:35
ok
User 19/07/2018 - 07:35
i see
Excelchat Expert 19/07/2018 - 07:35
Use custom formula =\$A2="name"
User 19/07/2018 - 07:37
funny mac excel dosnt allow that
Excelchat Expert 19/07/2018 - 07:39
Suppose it do that
User 19/07/2018 - 07:39
it dosnt give a apply to range
User 19/07/2018 - 07:42
i got it >.<
User 19/07/2018 - 07:42
=\$D\$2:\$H\$2=XFA2="Name"
User 19/07/2018 - 07:43
so complicated...
User 19/07/2018 - 07:43
lol >.<
User 19/07/2018 - 07:43
=\$D\$2:\$H\$2=(A2="Name")
Excelchat Expert 19/07/2018 - 07:43
Does it work?
User 19/07/2018 - 07:43
yes ty
User 19/07/2018 - 07:46
the last step is to make the rule apply to different things if the value is meet
User 19/07/2018 - 07:47
A2=Name hightlight b2-d2
User 19/07/2018 - 07:47
A2=pet highlight b2-c2
User 19/07/2018 - 07:47
ect but as a rule not as a row function
Excelchat Expert 19/07/2018 - 07:48
So you need to add two roles.
User 19/07/2018 - 07:48
but a2-a36 is name highlight the reflective voes
User 19/07/2018 - 07:48
boxes

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

Trusted by people who work at