conditonal format

  1. Rob_010101

    VBA Clear Conditional Format

    Hello I have the below code which moves a row of data to another sheet based on a value selected from a list. When the list item is selected, I'd like the row to be moved to the "LTS" sheet with all conditional formatting removed. Is this possible? Private Sub Worksheet_Change(ByVal Target...
  2. F

    IF statement problem

    Hello, I'm having trouble with calculating a formula. Refer to the numbers below for the questions. 1. I want to calculate if the PIR price equals the Invoice price to change the PO price to the PIR price. 2. Then if the PIR price and Invoice price don't match up, color code the Invoice with...
  3. C

    Conditional formatting...if current cell contains x and another cell contains y

    Hi all, A question regarding conditional formatting. Here is my current situation. <tbody> A B 1 Name DOB 2 John 01/01/01 3 Jack 02/01/01 4 John 01/01/01 </tbody> I want it so that when there are 2 of the same names with the same DOB that all of those fields in A will be...
  4. H

    Conditional formatting based on past and future dates

    Hi all, I'm struggling to know the right order to put the conditions in, if anyone could help please. I would like empty cells to stay blank/white Any cells with dates in the past or in the next two weeks (i.e past due or due soon) to turn RED Any dates not due in the next two weeks can stay...
  5. B

    Conditional Formatting with text

    I have a list of first and last names in column A, some first names repeat. I want to type in a first name in some cell (say H1) and all the cells in the list that have that same first name will be highlighted yellow.

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