conditional formula cell values

  1. K

    Conditional Formula

    What conditional formula can I use that will take use cell D3 (number in the orange frame box), then highlight the row base on the value? Example Below: #16144 should highlight row 17? Example: If the # is 42,000 then highlight row 2, but if its right under 45000 then highlight 3
  2. szita2000

    Is it possible to pick up the <>= symbols from a cell for a conditional formatting?

    Hi guys. I am trying to build a sheet where our management can set targets based on cell values, and the <,>,<=,>=,=symbols in another cell. Here is my mock up for the conditional formula which does not evaluate at the moment. I also tried to operate with the INDIRECT formula to pick up the...

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