+ Reply to Thread
Results 1 to 6 of 6

Cells turn red when you input data

  1. #1
    Registered User
    Join Date
    12-01-2009
    Location
    Pembroke Pines, FL.
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Cells turn red when you input data

    I have a spread sheet and when I enter informaiton for some reason it turns the cell red. I am fairly new with excel and can not figure out why. I never set it up to change color and have looked everywhere the cell is set up to only allow 50 characters to be enter but even if you enter less than 50 it turns red. I thought maybe its how the info I am entering is entered, for example LSF-halloweensouthflorida/halloween091/bullethole. I clicked on format cell and tried different option but it still turns red when you hit enter. I went to fill option but their is no fill. Does anyone have any suggestions?
    Last edited by Xiomy004; 12-01-2009 at 01:15 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Cells turn red when you input data

    Go to the Home Tab and then Conditional Formatting... select Manage Rules.

    Are there any rules there?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    12-01-2009
    Location
    Pembroke Pines, FL.
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Cells turn red when you input data

    I do not see where conditional formating is. My only options are clipboard, font, alignment, number, cells, editing?

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Cells turn red when you input data

    You don't have a Styles option?

  5. #5
    Registered User
    Join Date
    12-01-2009
    Location
    Pembroke Pines, FL.
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Cells turn red when you input data

    Sorry I found it, Yes there are.

  6. #6
    Registered User
    Join Date
    12-01-2009
    Location
    Pembroke Pines, FL.
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Cells turn red when you input data

    Thank you that solved my problem!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1