Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Conditional formatting help
Name: bwdeikken Date: September 9, 2008 at 08:14:50 Pacific OS: XP CPU/Ram: 512 Product: brick
Comment:
Ok so I have a spread sheet in excel and I need 3 Conditional formatting. The first one is set Cell Value is less then A38 (i have the cell set up as today()-1095 to get the date set to three years ago) change cell color to yellow. The second one is set up if its larger then A38 then it turns a blue color.
Now this is where I get stuck. I need another one so if there is no date in the cell I need it to stay white or even another color but I can't figure out how to do that. I've tried to set it up so its equal to a blank cell but it stays yellow all the time. Any ideas would be greatly apprciated.
Name: JRComp Date: September 9, 2008 at 08:50:27 Pacific
Reply:
What version of excel are you working with?
0
Response Number 2
Name: bwdeikken Date: September 9, 2008 at 08:54:19 Pacific
Reply:
Sorry I'm running 2003
0
Response Number 3
Name: JRComp Date: September 9, 2008 at 09:01:15 Pacific
Reply:
Set the third one up so that it will format any cell that is less than say 1/1/1000, that way, any blank cell will register as less than 1/1/1000.
Because i doubt that you will be entering any dates that actually are older than that date
0
Response Number 4
Name: bwdeikken Date: September 9, 2008 at 09:09:43 Pacific
Reply:
Thanks that worked kinda of it got me on the right track tho. I had to put the first Conditional formatting as my blank square other wise it was thinking that everything was less then my date and was turning everything yellow. The second Conditional formatting was my if the date was greater and my third was if it was less then three years ago. So far it seams to work. Thanks for the help.
0
Response Number 5
Name: DerbyDad03 Date: September 9, 2008 at 09:36:23 Pacific
Reply:
re: What version of excel are you working with?
JRComp, learn me something...
How would your answer have been different if a different Excel version was being used?
0
Response Number 6
Name: JRComp Date: September 9, 2008 at 13:04:38 Pacific
Reply:
Derby, I have not used excel 07 much, but i do know there are some bigger changes with it. Had he have said 07 i would have gone and tried it on a machine with 07. I asked that before i even knew what i was gonna try. no need to be malicious there chief
0
Response Number 7
Name: Bryco Date: September 10, 2008 at 05:36:37 Pacific
Reply:
Fair question followed by a good answer up to but not including "no need to be malicious there chief"
Bryan
0
Response Number 8
Name: DerbyDad03 Date: September 10, 2008 at 08:50:08 Pacific
Reply:
Thanks for coming to my defense, Bryco.
I was hoping my question wouldn't be taken the wrong way, but it appears that it was.
I guess the "learn me something" line didn't help.
0
Response Number 9
Name: JRComp Date: September 10, 2008 at 09:37:16 Pacific
Reply:
I apologize for my response then derby, I took your post for something it was not
0
Response Number 10
Name: DerbyDad03 Date: September 10, 2008 at 09:53:56 Pacific
Reply:
No problem...
Sometimes it's easy to mis-read the "tone" of an electronic message.
0
Response Number 11
Name: Bryco Date: September 11, 2008 at 12:46:32 Pacific
Reply:
DerbyDad03,
I am more familiar with your electronic tones. :)
Regards, Bryan
0
Response Number 12
Name: DerbyDad03 Date: September 11, 2008 at 13:56:47 Pacific
Reply:
Hmm...in that case you should have assumed I was being malicious!
;-)
0
Response Number 13
Name: JRComp Date: September 12, 2008 at 06:49:27 Pacific
Summary: I am looking to set up conditional formatting based on the first 3 letters of a particular cell. So if the cell says VACMOM or VACDAD or VACSISTER the cell would change colors but if it said VICKY or...
Summary: Is there a way to set up conditional formating to format a cell if another cell meets a certain criteria? ie. if "cell a" > 150 then highlight "cell b" else do nothing. your help is m...
0 
