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 🙂
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.Conditional formatting different cells
Hi all, I hope you can help me out here. As you can see in the picture the color of cel A15 till C22 needs to be blue if B20 = 3-Afgehaald. The color needs to be green if B20 = 2-Bevestigd, Gray with white text if B20=4-Teruggebracht. The same formatting needs to work on cell A25 till C32 if B30 is 2-bevetigd or 3-afgehaald or ... At this moment I need to copy the formatting and changing the values of every block. That for 365 days by 2 blocks? Hope some vba code could help. Something like If B20=2-Bevestigd cell-4 till +30 will be that conditional formatting. Many thanks Peter
Conditional formatting
Can someone please tell me where I am going wrong with my conditional formatting? I am trying to set it up so that a cell will turn red if the number input is less that the corresponding number in the first column of that row. So, if the number in A2 is 97 and 96 is put in B2, it will turn red. However, if 103 is in C2, it won't turn red. I want each row to work independently and look at the first cell in the corresponding row only. Thanks
