conditional format mod()

  1. T

    Conditional formula to draw lines at 45, 90 and 180 degree

    I have an excel file containing values from the Square of Nine and would like to add conditional formatting to include: 1. horizontal line at 180 degree angle 2. Vertical line at 90 degree angle 3. diagonal line at 45 degree angle Can you help formulate a formula that can be enabled as a...
  2. H

    Conditional Format based on every other cell in a column

    Right now I have a list of numbers from A1:A8. I want B1 to have a conditional format that looks at A1:A8, skips every other cell (A2, A4, A6, and A8), and let me know if either A1, A3, A5, or A7 have a value of less than 1 (0 or negative). So its skipping every other row and only looking at...

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