Is anyone handy with MS Excel?
12-23-2009, 12:38 PM
#11
Registered User
Join Date: Nov 2003
Location: Long Beach
Posts: 948
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Gatsbee13,Dec 23 2009, 01:10 PM
its quite simple: want to make column x,y,z the color grey if say column d = N
Conditional Formatting -> highlighted cell rules -> Cell Value equal to N -> custom format (change the cell fill color to gray)
thats on excel 07. I havent used the older version in a while, but its the same basic idea
12-23-2009, 02:08 PM
#13
Registered User
Join Date: Apr 2007
Location: SoCal
Posts: 9
Likes: 0
Received 0 Likes
on
0 Posts
Highlight the range X,Y,Z you want to use.
Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format
In the "Format values where this formula is true" box, type the following:
=$D1="N"
If you are not starting with D1, then change the 1 to whatever row # you want to begin with.
Click Format and set the Fill to whatever color you want.
That works for Excel 2007.
Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format
In the "Format values where this formula is true" box, type the following:
=$D1="N"
If you are not starting with D1, then change the 1 to whatever row # you want to begin with.
Click Format and set the Fill to whatever color you want.
That works for Excel 2007.
12-23-2009, 02:16 PM
#14
Registered User
Join Date: Nov 2003
Location: Long Beach
Posts: 948
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Gatsbee13,Dec 23 2009, 01:52 PM
thats not going to work because it doesn't include column D.
that'll only work if Columns X,Y,Z contain the Value N.. in my case, i want columns X,Y,Z to be shaded grey if Column D has a value of N.
that'll only work if Columns X,Y,Z contain the Value N.. in my case, i want columns X,Y,Z to be shaded grey if Column D has a value of N.
Highlight columns x,y, and z
Conditional Formatting -> use formula to determine which cells to format -> =$D1="N" -> format -> change fill color
Key part is make sure the row number is not held constant, there should only be a $ in front of the D.
12-23-2009, 02:21 PM
#15
Registered User
Join Date: Nov 2003
Location: Long Beach
Posts: 948
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by nurb2,Dec 23 2009, 03:08 PM
Highlight the range X,Y,Z you want to use.
Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format
In the "Format values where this formula is true" box, type the following:
=$D1="N"
If you are not starting with D1, then change the 1 to whatever row # you want to begin with.
Click Format and set the Fill to whatever color you want.
That works for Excel 2007.
Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format
In the "Format values where this formula is true" box, type the following:
=$D1="N"
If you are not starting with D1, then change the 1 to whatever row # you want to begin with.
Click Format and set the Fill to whatever color you want.
That works for Excel 2007.
Thread
Thread Starter
Forum
Replies
Last Post
pierceman
California - Southern California S2000 Owners
0
11-22-2006 02:10 PM