Question description:
This user has given permission to use the problem statement for this
blog.
For some reason i'm having a mind blank about how to extend conditional formatting rules further down the sheet. I have all the rules I need applied to the top cell, but now I need all the cells in column c to have the same rule, but corresponding to column b cells without retyping the rules for each individual cell.
For example, cell C2 should turn red if < than cell B2. I now need cells C3 thru C38 to turn red if < than cells B3 thru B38.
Not sure if that makes sense!
Solved by I. J. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
14/08/2018 - 02:40
Welcome, Thanks for choosing Got It Pro-Excel.
User
14/08/2018 - 02:40
thanks! not sure if my question makes sense. Let me know if you need anything clarified
User
14/08/2018 - 02:41
it's been a while since i used excel this way so I need to brush up a little
Excelchat Expert
14/08/2018 - 02:41
Okay.
Excelchat Expert
14/08/2018 - 02:41
Do you have sample data?
User
14/08/2018 - 02:42
yes. can i copy and paste into this worksheet
Excelchat Expert
14/08/2018 - 02:43
Just upload it...
User
14/08/2018 - 02:44
how? google drive? sorry
Excelchat Expert
14/08/2018 - 02:45
Just use the upload button to the right-end of the chat input box.
User
14/08/2018 - 02:45
this work
[Uploaded an Excel file]
Excelchat Expert
14/08/2018 - 02:46
Going through it...
Excelchat Expert
14/08/2018 - 02:48
I see the rules are applied to the range:
Excelchat Expert
14/08/2018 - 02:48
=$C$2:$C$38
Excelchat Expert
14/08/2018 - 02:49
Are you there?
User
14/08/2018 - 02:49
yes. that's correct
User
14/08/2018 - 02:50
i need to change the rule to apply to B2 thru B38
Excelchat Expert
14/08/2018 - 02:50
very good.
Excelchat Expert
14/08/2018 - 02:50
Are you using the online sheets or Desktop application?
User
14/08/2018 - 02:50
desktop
Excelchat Expert
14/08/2018 - 02:51
Okay. We will have to make this automatic.
Excelchat Expert
14/08/2018 - 02:51
Let me formulate a formula for you.
User
14/08/2018 - 02:51
thank you.. appreciate it
Excelchat Expert
14/08/2018 - 03:01
Almost done.
User
14/08/2018 - 03:01
ok thank you
User
14/08/2018 - 03:19
hello sir I have to get on a conference call shortly.. would you be able to email me the formula when complete? so sorry for the inconvenience
User
14/08/2018 - 03:21
my email is brittanywarrilow@gmail.com
Excelchat Expert
14/08/2018 - 03:24
Hello, are you there?
User
14/08/2018 - 03:24
yes
Excelchat Expert
14/08/2018 - 03:24
Conditional Formatting:
[Uploaded an Excel file]
Excelchat Expert
14/08/2018 - 03:24
I have applied the conditional formatting for you.
User
14/08/2018 - 03:24
perfect thank you so much
Excelchat Expert
14/08/2018 - 03:25
It was my pleasure helping you solve this problem. Any time you have a problem with Excel do not hesitate to come back for help.
Excelchat Expert
14/08/2018 - 03:25
You can always end and rate the chat at any time for better services. Hope to see you again!
User
14/08/2018 - 03:25
thank you again!
Excelchat Expert
14/08/2018 - 03:26
Welcome!
Excelchat Expert
14/08/2018 - 03:38
After merging:
[Uploaded an Excel file]
Excelchat Expert
14/08/2018 - 03:39
After Unmerging:
[Uploaded an Excel file]
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.
