lesser

<tbody> Goal 07/02/18 07/03/18 07/04/18 07/05/18 50 20 56 65 130 50 22 25 35 85 106 130 120 85 99 120 115 160 55 96 150 16 175 199 12 </tbody> Hi - I need a macro which needs to fill the colorindex=22 whenever the ACTUAL is lesser than the GOAL. For...

Hi i am writing a program which where the user will search data base on the value in the dropdown combo box in the userform. The user can only select the options base on the combo box, there are 3 of them 1st: the type of ship: it will determine which sheet it will open 2nd: Tonnage: which will...

Hi all, Hoping to get some help with this problem.. What I need is a formula for column N which automatically calculates how many of the %numbers in column N (2:22) are lesser or equal to 15% and expresses this as a percentage. In this case answer is 76.2%. I hope this makes sense, Thanks...

I need to have a cell change color based on whether another cell is of greater value or lesser value. Greater Green, lesser Red The first number (1) would be neutral but then the next (2) would be green because its greater than and the next number (1) would be red because it dropped below the...

When entering a formula in a post containing the " lesser than" operator all text starting from and including this operator disappears when I save the post. Any work around available? Thanks

Hi, I want to edit a value in a certain cell. The situation goes like this; Case 1: Let's say the value is 7.0, so the value remains 7.0 Case 2: Let's say the value is 7.333 which is lesser than 7.5 but greater than 7.0, so the value is changed to 7.5. Case 3: Let's say the value is 7.5, so the...