Cell shading question...

D

djroppolo

Board Regular
Joined
Jun 25, 2005
Messages
66
Suppose I am entering data into a simple spreadsheet, starting at cell A7 and ending at I7. Could I have the entire row from A7-I7 shaded a certain color depending on the value of I7? Also, how would you modify that to work on every row of the spreadsheet?

Thanks in advance :)
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
Have a look at Conditional Formatting in the Hel file.

Post back if you need assistance with it.
 
Upvote 0
Welcome to MrExcel Board!

It depends on how many colors of shading you're going to want. If it's 3 or less, you can use conditional formatting. If you've never used it before, have a look at the help file on it. If you're always going to be basing the colors off of I7, you can use the "Cell Value Is" condition, otherwise, you'll probably want "Formula Is." You can do some really neat things with conditional formatting.

If you still need help after that, post back with some more details like how many formats you need, and what the cutoffs are for each format (e.g. If less than 2, format green background, between 2 and 8, red background, etc.).

Hope that helps!
 
Upvote 0
Tazguy37 said:
Welcome to MrExcel Board!

It depends on how many colors of shading you're going to want. If it's 3 or less, you can use conditional formatting. If you've never used it before, have a look at the help file on it. If you're always going to be basing the colors off of I7, you can use the "Cell Value Is" condition, otherwise, you'll probably want "Formula Is." You can do some really neat things with conditional formatting.

If you still need help after that, post back with some more details like how many formats you need, and what the cutoffs are for each format (e.g. If less than 2, format green background, between 2 and 8, red background, etc.).

Hope that helps!
Click to expand...

That helped some. Depending on the value of (I,*) I would like the entire row to be shaded a single color. Every cell in that row, not a different color for each cell. So if I,7 is equal to 'Jennifer', then shade the range of A7-I7 in orange. Each girls name will have its own color for her row.
 
Upvote 0
Conditional Format Demo..

1. Select cells A7:I7 ( do rest while all cells are still selected)

2. Goto ToolBar...Format ...Conditional Format

3. In conditional format do the following ...
3a. Choose "Formula is " in drop down
3.b. copy in formula =$A7>10 ... including equal sign
3.c. click format button in conditional format window and choose format
3.d. click ok buttons

Test it out ... type numbers >10 and <10 in cell A7


If like just copy down rest of the rows ... :wink:
 
Upvote 0
Nimrod said:
Conditional Format Demo..

1. Select cells A7:I7 ( do rest while all cells are still selected)

2. Goto ToolBar...Format ...Conditional Format

3. In conditional format do the following ...
3a. Choose "Formula is " in drop down
3.b. copy in formula =$A7>10 ... including equal sign
3.c. click format button in conditional format window and choose format
3.d. click ok buttons

Test it out ... type numbers >10 and <10 in cell A7


If like just copy down rest of the rows ... :wink:
Click to expand...

Yes, that worked like a charm. What would the formula be if I need shading based on a text entry.

=$I7="Jennifer" ???
 
Upvote 0
Nimrod said:
Hello djroppolo

With Strings you put Quotes around it ...

=$I7="Jennifer"
Click to expand...

Awesome... I wish I had found this board about a month ago. I will definitely be hanging out here DAILY for help. You guys rock. :cool:
 
Upvote 0
hello djroppolo :)


1. Is there a wildcard for the row#???
Click to expand...

..... What are you trying to achieve here ??



2. How do I do more than 3 conditions?
Click to expand...

..... You will need to write code into the On_Change Event of the sheet to get more then 3 formats.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
SUMIFS between two dates not working :S
2
Replies
11
Views
568
Peter_SSs
Peter_SSs
M
  • Question
Clear contents in column range based on criteria
Replies
2
Views
235
Peter_SSs
Peter_SSs
sparky2205
  • Question
Maintain formats while copying rows in protected sheet
Replies
0
Views
303
sparky2205
sparky2205
F
  • Question
Sumifs with any one or more of multiple criteria
2
Replies
12
Views
861
Dave Patton
D
P
  • Solved
Button produces different result
Replies
3
Views
97
RoryA
RoryA

Forum statistics

Threads
1,214,625
Messages
6,120,598
Members
448,973
Latest member
ksonnia

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top