Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    14

    Unanswered: How to base an if statement base on colour?

    I want to add a formula or an if statement that will look at the text properties in one cell and if it is the color red, then change the value of another cell. So basically I have a column of values(numbers) colour coded red and black. If a cell number is red, then make the value in the cell next to it 10, if it is black, then make the value of the cell 0.

    Please let me know if I can do this.

    Thanks

    Sherriff

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    Take a look at this

    http://www.cpearson.com/excel/colors.htm

    HTH
    texasalynn

Posting Permissions

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