if then formatting

  1. H

    Having trouble with if then statement

    Hi All, I am trying to do the following: in my workbook H34 (It is actually H,I,J as those three fields are merged) is H12 (H,I,J) * 100 I need to write a formula so that if H34 is less thqn $2500 it will multiply the number of locations (H12 x $100), but if H34 is $2500 or more it will enter...
    • hipmrc
    • Thread
    • if then if then formatting if then formula
    • Replies: 6
    • Forum: Excel Questions
  2. J

    Conditional Formatting

    Is it possible to us conditional formatting to tell excel "if a cell in range A1:A10=number then format the cell next to it in column B if that number is not a number 1-10?" For example: A1= 10 A2= 1 A3= 9 A4=5 A5=6 A6=4 A7=7 A8=3 A9=8 A10=2 B1= 1 B2= 15 B3= 2 B4= 3 B5= 4...
    • jhow659
    • Thread
    • conditional formatting help is needed if then formatting
    • Replies: 1
    • Forum: Excel Questions

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