Hello All...
I am trying to use conditional formatting to make D1="NONE' if C1="NO'. I can use the IF formula to do this one cell at a time, but I was trying to use conditional formatting so as additional rows are added, this process is more automated. Any suggestions?
Requirement: To highlight the largest value and lowest value of the range.
The values in the range are obtained from countif() formula (for e.g. for March 4th, formula is COUNTIF('A:A,"04.03.2021"))
What I did: I am using conditional formatting rules: Top 1 and Bottom 1 to highlight the...
Hello everybody,
I have the following list of information:
Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :)
Thank you very much everybody.
Best regards,
David
I'm trying to create a chart using conditional formatting that will show the hours that each employee is working. I have a formula for that works for Chris' time but can't figure out a formula that covers both Chris & Richard's schedule since Richard is working overnight. Richard's hours...
Hello!
Simply, I was wondering if anyone had a method for conditional formatting (Font Color) for a row based on whether or not the last four digits of an asset appear in a separate table.
(Table A) I've got a spreadsheet that has a large list of equipment as well as columns with current...
I have the following formula in conditional formatting. This formula is working correctly in October column (column H) but highlight only on cell H2. What do I need to change so that formula work for column H,(October).
=AND(MONTH(F1)=MONTH(TODAY())-1,F2="")
F1 is August, G1=Sep. H1=Oct...
I have a spreadsheet that I have been using for about a year and a half with no issues. It has conditional formatting for the whole row to highlight yellow based on the date in one column or go red based on the date in another column. The red date has the stop if true checked. I have made no...
Hi
I have linked a range of cells on one worksheet in the same work book to another sheet in the same workbook but I have lost all the formatting. Is there a way to preserve the formatting? I am using Excel 2007 and conditional formatting.
Hey guys,
I'm new here and have really no idea what I'm doing but here goes nothing.
So I've been asked by a friend to help out with her excel spreadsheet, and i just can't figure out how or what I should do to create the function I desire
Basically, she works in a school, and there are...
I have a timeline the teams previously cut and paste color code phases of the project (planning, build, requirements, develop, etc.). I developed a workbook with a formula page that the timeline now works off start and stop dates of the phases. I have a formula page of =if(and identifying each...
All,
Is there a way to color cells based on a value that is not contained? For my application any cell that doesn't contain the word "complete" would be yellow and every cell that does contain the word "complete" would be green. I know how to format the cells to turn green when complete is...
I explain what I want the macro to do in the picture and provide a basic layout of how the sheets are exported from an internet application. I wrote a macro to format the sheets from an unreadable formatting to a user-friendly format. However, I cannot figure out how to change the whole row's...
Hello all; Here is the problem: I have a column showing different types of currency so A1 could show "USD", A2, "GBP", A3, "JPY" etc. in adjacent column I want the format of the value to reflect the type of currency, "$" for USD, "Pound sing" for GBP, etc. Sounds easy enough but I can't...
windows 7-64, excel 2007
i have tried 3 or 4 different ways for the last 2 days, i get close but no luck, I need a fresh set of eyes.
Driver ___ 4/1/12 ___ 4/2/12___ 4/3/12___ 4/4/12
xxxxxxx ___blank _____ NV _____ blank ___ blank...
I use macros extensively in my work and recently wondered if I could speed things up by merging files into one workbook and applying the macro using the option to apply to all sheets . Fixed formats for column and row dimensions work ok but color coding with conditional formats do not. I am...
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.