Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 7th 04, 02:48 AM
bpat1434
 
Posts: n/a
Default Modify Row & Cell Contents based upon Cells Values


Thanks for your help. You helped me understand a bit.

Only problem I have here is this:

I'm already using conditional formatting to color alternate rows a
light shade of blue (instead of the gray. If I can use autoformat to
clear up a conditional, please tell me how to do this while keeping the
same color scheme.

I'm also using a conditional format to modify the row color based upon
if the item in $K2="Picked Up".

The value of $K2 is actually a drop down box with two choices, and two
choices only.

$B2 is actually a properly formatted date (12/12/2004) so I figure
using DATEVALUE($B2) would work.

So, is there a way I can combine the two conditional formats of any
suggested or current? i.e. combine the alternate row & $K2="Picked Up"
or the two suggested.

Thanks for the help.

~Brett Patterson


--
bpat1434
------------------------------------------------------------------------
bpat1434's Profile: http://www.excelforum.com/member.php...o&userid=16155
View this thread: http://www.excelforum.com/showthread...hreadid=275903


  #2   Report Post  
Old November 7th 04, 03:12 AM
Dave Peterson
 
Posts: n/a
Default

You can have up to 3 conditions for your conditional formatting. The first one
that returns true wins. So if you want red, then grey, then lightblue, make
sure that the lightblue conditional formatting is condition 3.

(There's a button on that CF dialog that allows you to add more conditions (up
to 3 total).

If you have 12/12/2004 in B2, try =datevalue($b2) in an empty cell as a test.
What do you get?

===
Did you really mean autoformat (like in Format|Autoformat...)? It doesn't sound
like you need it to me.

bpat1434 wrote:

Thanks for your help. You helped me understand a bit.

Only problem I have here is this:

I'm already using conditional formatting to color alternate rows a
light shade of blue (instead of the gray. If I can use autoformat to
clear up a conditional, please tell me how to do this while keeping the
same color scheme.

I'm also using a conditional format to modify the row color based upon
if the item in $K2="Picked Up".

The value of $K2 is actually a drop down box with two choices, and two
choices only.

$B2 is actually a properly formatted date (12/12/2004) so I figure
using DATEVALUE($B2) would work.

So, is there a way I can combine the two conditional formats of any
suggested or current? i.e. combine the alternate row & $K2="Picked Up"
or the two suggested.

Thanks for the help.

~Brett Patterson

--
bpat1434
------------------------------------------------------------------------
bpat1434's Profile: http://www.excelforum.com/member.php...o&userid=16155
View this thread: http://www.excelforum.com/showthread...hreadid=275903


--

Dave Peterson



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I link many cells to one particular cell? justinfishman22 Excel Discussion (Misc queries) 2 January 4th 05 12:09 AM
I want to format a cell based on an adjacent cells value Cumbo Excel Discussion (Misc queries) 1 December 13th 04 11:52 AM
Modify Row & Cell Contents based upon Cells Values bpat1434 Excel Worksheet Functions 1 November 6th 04 05:17 PM
Modify Row & Cell based on Multiple Data Brett Patterson Excel Worksheet Functions 0 November 5th 04 07:11 PM
Modify Row based upon cell value Brett Patterson Excel Worksheet Functions 0 November 4th 04 11:09 PM


All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017