Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    Unanswered: Conditional Formatting Help!

    I need to create a conditional formatting,

    I need to hightlight from A1:A18

    In the above cells I have values from 1 to 4

    So I need to fill the cell with 4 different colours.

    If cell equals 1 = Green
    If cell equals 2 = Yellow
    If cell equals 3 = Red
    If cell equals 4 = Blue

    What I do is highlight cell from A1:A18, clik on 'Format', 'Conditional Formatting', I've tried using 'Cells Value is' and 'Formula is'.... but with no luck

    Can anyone help
    Attached Files Attached Files

  2. #2
    Join Date
    Feb 2007
    See attached file. Hope it helps
    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