Results 1 to 5 of 5

formula problem w/ conditional formatting

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    manila
    MS-Off Ver
    Excel 2010
    Posts
    16

    formula problem w/ conditional formatting

    hi guys,
    need help for this problem, can someone help me to make formula in conditional formatting.
    i try to make this but it work only in separate cells =IF(G4>125,0,1) & =IF(G4>125,ROUNDUP(G4/250,0),0).
    but not in formula for conditional formatting.

    in simple ways:
    less than 125 device, maximum 1219 meters (more than 1219 it turn red)
    between 126 up to 175 , maximum of 762 meters (more than 762 it turn red)

    thanks!
    Attached Images Attached Images

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