less than greater than

  1. N

    Formula to flag if value is greater than or less than 90

    How would I word a formula to flag if a cell is greater than or less than 90? I want to search 2 columns (Z and AA) and tell me if any of the values are greater than or less than 90 and exclude zero's and text by putting "BRACKET" the cell the formula is in. How would I word that in a formula?
  2. B

    Conditional Formatting 'greater than/less than' for cell containing variable date based on a formula

    Please please please someone help! I have a spreadsheet as below. A2 - 'Date Approved' is manually entered, B2 - 'Review Date' and C2 - 'Trial Expiry' are automatically calculated based on the date entered in A2 - 'Date Approved'. I need to conditionally format as follows: B2 - Cell to turn...
  3. N

    Using a COUNTIFS formula with a less-than criteria

    Below is the table I am working with. The "Call Sequence" column is just a continuous list of Calls (1 to 2221). There are 11 different call types with 11 corresponding Prefixes. Because there are many calls of the same Call Type I would like to count them. I also want to have the "Suffix"...
  4. Q

    IF Statement Help = (Greater Than and Less Than Statements) and Blank Cells

    I have three columns as follows: Column A: Provides the number of days permitted to complete a task Column B: Provides the number of days that it actually took to complete the task Column C: This is where I need my IF Statement to calculate a simple Yes or No if the Actual Days to complete...
  5. R

    If Function - Excel 2010 - Need him putting together a function

    I need help with a formula for one of my cells I want to write: If D3 is greater than 90%, highlight the current cell green and write "Okay", if d3 is less than 90% but greater than 70%, highlight cell yellow and write "okay-ish", if D3 is less than 70%, highlight the cell red and write...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top