Results 1 to 4 of 4

High Medium and low

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Nottingham
    MS-Off Ver
    Excel 2003
    Posts
    15

    High Medium and low

    Hi,

    I need to add a colour and Text in a cell influenced by the number in a second cell, so if the number is equal or between 1 and 2 i want the cell to go green with the text 'LOW', if the number is equal or between 3 or 4 i want the cell to go yellow with the text 'MEDIUM' and if it is equal or between 6 and 9 i want the cell to go red with the text 'HIGH'.

    I have attached an example.

    Thank you for your help.

    Regards,
    Stuart.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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