conditional format if

  1. B

    Need help to conditionally format a cell in one cell of a table based on the values of two other tables

    I am struggling with finding a way to highlight cells in my data preferably using conditional formatting in colour for sorting the following or flagging in some sort. My actual data source has about 8,000 people so manual sorting is not needed and I need to make sure I record each step for...
  2. E

    Conditionally format one cell based on another cell being blank in Excel

    I have two columns of cells, one with the Due Date and one with the Received Date of certain parts. If the Received Date column is blank, I want to compare the Due Date to today's date and conditionally format the cell if the part is overdue (red) or if it is due within two weeks (yellow). If...
  3. N

    Conditional Formatting: If at least one cell in a row contains at least 1 of 100+ options

    Is there a way to setup a conditional formatting formula to highlight if at least one cell on a row contains at least 1 of 145 possible codes. Column O contains a list of 45 codes. I need to know how to check that each row contains at least one of the 145 codes listed. There are over 1,000...
  4. A

    Help with formula for scheduling staff

    Hi All, I need some help with a formula. In Column A I have the persons name, Column B i have the start time of a persons shift. In column C i have the end time of that shift. The shifts can be any back to back combination of 5 minutes from 7am to 8pm so there are a total of 156 possible shifts...
  5. C

    Conditional Formatting Rules

    Hi, I would like to condtionally format a number of cells only if a particular cell is populated with yes or no: if H3 = "No" then cells A3:H3 = Red Fill with White text How do I achieve this. Thanks C16
  6. R

    Conditional Formating Dates

    Hi there I have a speadsheet where the current date will be entered when a product has been place on hold. the sales reps then has 2 days to complete this sale, after 2 days are up i want the date in the cell to be highlighted red. If no date is entered into the cell yet i would like it to...
  7. C

    vba simple Conditional Format IF = to "x" using both TEXT and NUMERIC code?

    Using this simple code to conditionally format cell if "X" is true, can someone share what the most simplistic way is ~ to accomplish this whether it be with NUMERIC or TEXT methods? IF NEEDING TO CONDITIONALLY FORMAT NUMER: (THIS CODE WORKS GREAT BUT IS THERE A SHORTER MORE SIMPLISTIC WAY?)...

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