Conditional Formatting on whole column with variable reference cells
Hi, I'd like to format the colour fill of multiple cells within one particular column, when it's value is less than a cell in the row above of the next column. how should I do this please? eg. when the value of D93 is smaller than the value of E92 format fill red. Apply to all D's. So far I have established that if I type =($D$93<$E$92) then I can make the rule work for cell D93. But how can I replicate this formula throughout the whole of the D column, without typing for each individual cell. Is this even possible? Is there a short cut to copying the rules over? Thankyou 🙂
Conditional formatting for decimals
Hello Experts, I am creating an excel sheet where user will have to put values with 4 decimal places. The value will turn red if it does not have four decimal places (i.e. more or less decimals places). I formatted the cells as number with four decimals and red font, so all input values become red (regardless of decimals places). Then, I applied the conditional formatting with formula =LEN($D6&"")-FIND(".",$D6&"")=4, and conditional formatted the font black, so all input values with four decimals turn black. Everything works fine till this stage. I have an issue while I put value with four decimals places, but zero at fourth decimal place (e.g. 1.1110). The excel doesn't consider trailing zero at a decimal, and doesn't convert the value to black. I am sure I am missing something here. Your support will be highly appreciated. Thanks in advance!!
Formulas to highlight cells
Hello! Thank you so much in advance for your help! I have a cell in A1 that contains: Composer A (BMI) 50% [292650159], Composer B (ASCAP) 30% [154541151], Composer C (SESAC) 10% [55547898], Composer D (SESAC) 5% [4125475], Composer E (SOCAN) 5% [02124054] 1) I'd need a formula to use in Conditional Formatting that will turn this cell green if the sum of the % equals 100%. 2) I'd need another formula to turn the cell red if the sum doesn't equal 100%, and no highlighting if the cell is empty. *** I have another cell in B1 that contains: Publisher A (BMI) 50% [612559885], Publisher B (ASCAP) 35% [02135474], Publisher C (SESAC) 15% [01023545] I'd need a formula to highlight the cell in green if the percentages for BMI and SESAC match the ones in the previous cell (A1) for composers and if the sum of all the % in this publisher cell equals 100% (SOCAN composers go under the ASCAP publisher in this example that's why there is no Publisher for SOCAN). The cell should be red if there is an issue with the % splits. I really appreciate your help! Thanks again!
Can not Manage Conditional Formatting Rules in Excel 365
Hi everyone, I was wondering if it is just me but I can not see the menu option to "Manage Rules" that is normally in the Conditional Formatting drop-down menu. Please see the attached image. I do have these options in the offline Excel version however because I have a form linked I can't take it offline and then use it online again because I then need to create a new form that opens in another tab (if that makes sense). Is this a bug? Thanks for the help!
Conditional Formatting with Dates
How do I format so that certain adjacent cells will highlight if one of the cells is before current date. B4 C4 D4 E4 F4 4 BYRON LAKEVIEW NURSERY, LLC JONATHAN D. JAMES 39401 4/11/2016 I Need these cells to highlight to yellow if F4 is before today's date. How do I do this in conditional formatting?Cell Validation - Drop Down Lists and Text Formatting
Hi, I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/cell formatting i have in place (each option has a different colour of text and cell fill applied, with mixed font sizes within the same cell). Is there a away o can do this without also adding conditional formatting to the cell that contains the drop down? CF doesn't quite give the result i am looking for as it doesn't mirror the mixed font sizing i have in place for the actual list. Would appreciate any help you can offer with this. Thank you JCopying Conditional Formatting
I need to make one cell highlight when it is 10% over another cell. I know the format, however, I need to copy this format into a crap ton of cells. How can I get it to work for the rest of my cells so i don't have to input it for every single one. example: B1 $100 B2 $110 =B2>=B1*1.1 B3 $200 B4 $220 =B4>=B3*1.1 B5 $300 B6 $330 =B6>=B5*1.1 I need B2 to change, B4 to change, & B6 to change. I can't copy the formatting because it only copies the original formatting and doesn't continue it down the line with new cells. Any suggestions? I have 10 workbooks to do this to with about 200+ cells in each and I dont want to spend weeks on this.
