Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Excel help needed please.

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel help needed please.

Old 12-16-03, 02:50 AM
  #1  
DVD Talk Ultimate Edition
Thread Starter
 
Join Date: Jan 2001
Location: Seattle
Posts: 4,454
Likes: 0
Received 0 Likes on 0 Posts
Excel help needed please.

I thought I knew how to do this but I am having trouble. I want a cell to change it's cell color if a certain character is typed in the cell.

In other words if the cell is empty there is no color fill. If a W is typed in the cell color will change to X color. If an O is typed into the same cell the color will change to Y color.

Any ideas?
Old 12-16-03, 04:30 AM
  #2  
DVD Talk Gold Edition
 
Join Date: Oct 2000
Location: Seattle
Posts: 2,349
Likes: 0
Received 0 Likes on 0 Posts
You want conditional formatting. It's in the "Format" menu toward the bottom. It's pretty self-explanatory from there.
Old 12-16-03, 04:21 PM
  #3  
DVD Talk Ultimate Edition
Thread Starter
 
Join Date: Jan 2001
Location: Seattle
Posts: 4,454
Likes: 0
Received 0 Likes on 0 Posts
Thanks...I forgot all about that. The rub is though it only allows you to have three different conditions and that's it. I have six different conditions. Why the hell would it limit it to just three conditions.

Last edited by palebluedot; 12-16-03 at 04:24 PM.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.