Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2007
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Newbie (excel 2003)

    I have been tasked to create a spreadsheet that tracks all the Academic Tasks in my office. I have gotten the list done and the page looks pretty good but my question is how do i go about making a checkbox that when clicked it puts a strike through the whole line and changes the color of the words say like from red to blue with a strike through when the task is completed. But here is the tricky part i cant figure out. how can i make it so that when i un-cklick the checkbox it returns the text line back to normal? i just cant figure it out. someone help please

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Newbie (excel 2003)

    Welcome to Woody's Lounge!

    Putting a check box in many rows is not very easy in Excel. You could simply enter an x in a column to indicate that a task is completed. To change the formatting, you can use conditional formatting.

    In the attached workbook, the same conditional formatting has been applied to all cells in the range A237. It will change the font to green and strike through if the cell in column D in the same row contains "x". Click in any cell in the range A237 and select Format | Conditional Formatting... to see the condition, then click Format... to see the format I specified.'

    Feel free to ask more questions if needed.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •