conditioning formatting

  1. T

    I'm trying to use EDATE in conditional formatting to turn cells different colours and then use COUNTIF to count green and turn this into a percentage

    The conditioning formatting worked when using "cells that contain" but other forums say that it has to be a formula to then use count function. Please can someone help without using macros as I don't understand these.
  2. N

    Multiple conditioning formatting

    Hi, I'm struggling with excel and conditioning formatting. I want to highlight a cell based on two conditions but I don't know how. The result should be like this (because I don't have the permissions to add attachments, I've created a visual with a table): This is my Excel-sheet A B C...
  3. L

    Need help to apply top border in table with any text show in column A

    <tbody> PT# INI. EAU FY1 VENDOR TOOLING COST TOOL LEAD TIME(Wks) PEACE PRICE MIN. ORDER QTY. PT18104 JB 1,000 Cardinal Alum. CO. $4,200.00 5 $4.66 1 Dan's Alum. Die $4,800.00 4 $4.75 1 RW14554 JBP 1,000 Cardinal Alum. CO. $3,400.00 4 $2.50 1 Jacob's...

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