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...
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...
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...
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...
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
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...
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 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.