•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to stop data in new cells from inheriting formatting from previous rows?
Our take
If you're experiencing unwanted formatting inheritance in your spreadsheet, you're not alone. Many users encounter this issue when new data in certain rows adopts formatting from preceding rows, despite attempting to set fill colors to "none." This guide will help you understand how to maintain clarity in your spreadsheet by ensuring that new entries in rows 13-24 remain free of any unwanted fill colors.
I have a sheet where certain rows / columns have fill colors applied to make things easier to read.
For example: Rows 1-12 (Jan - Dec 2025 ) have a fill color. Rows 13-24 (Jan - Dec 2026) do not have any fill color with the exception of column B, which has the manager's name.
I can highlight the cells in rows 13-24 and set them to have no fill. But when I type a value in any of those cells and tab or enter, the cell inherits the color fill from the section above, even if the row directly above it has no fill.
There is no conditional formatting in use on the cells/rows in question.
I typed 15 in cell F9 and clicked enter, but I do not want this formatting to auto apply.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting highlighted cellsHoping you can help me! Everyone at my office is a huge novice with Excel - I understand the basics but am not terribly great myself. We need one (hopefully) simple thing. Essentially, we have a dataset that we want to flag column A with a highlighted color if anything in that row is a color. Column A will always contain one of 5 words -- I've already done that with data validation. But what we want is, for instance, if I highlight cell H7 in yellow, it would then highlight A7 with the same color. I tried playing around with conditional formatting but I wasn't able to get it quite right. Thanks in advance for any assistance you can give! submitted by /u/THE_GREAT_PICKLE [link] [comments]
- Excel Column Conditional FormattingI am working in an excel that gets updated daily. We are tracking daily values for metrics for a sports team (think training load, distance, etc.) I have conditional formatting for each individual day's column to identify those who are -2/-1/+1/+2 standard deviations from the team average with color coding so we can see who to rest more or can do extra conditioning. I need it to just pull that day when formatting the column. I managed to get the file set up and the rules set, but now when I add a new day's data, previous days' data are being affected and changing, and I believe being included as part of the average. I've been manually copy and pasting an individual day's formatting across and updating the entire sheet daily to fix it, but is there an easier way to stop this from happening? submitted by /u/Mdotb774 [link] [comments]
- How to make conditional formatting exclude blank cellsMaking a working hours chart but I'm not very well versed in many Excel functions so I've been consulting google results for most, but I don't understand why conditional formatting is marking blank cells green for value >0. The detailed issue is as follows: I have columns for for date (C), start time (D), end time (E), and the following (using row 5 for example): Total time F5 =IF(D5;E5-D5;"") Number format: Time Overtime: G5 =IF(OR(F40="";TIME(8;;)="");"";(F40-TIME(8;;))*24) Number format: General I have set up conditional formatting in column G to color everything that is below 0 red, everything above 0 green, but all the blank cells with above formula applied are colored green too. Cells that equal 0 are left without color, as I intended. My hope is that blank cells also remain white until they recieve a value. Is there a way to achieve that? I appreciate all the help! submitted by /u/ace_098 [link] [comments]
- Trying to figure out conditional formatting of a cell based on its value and the value of another cellOne column my data has a product type (e.g. 1A, 1B, etc.), and another column has an attribute (e.g. WD, HM, etc.) All product types can have all attributes. I'm trying to format the product type cell background based on a given combination of product type and product attribute (e.g. 1A + WD would be yellow, 1A + HM would be blue, etc.). I've tried using a formula to control the formatting (e.g. ($J19 = "1A" and $I19 = "HM")), and setting the fill color, but it does not appear to be working (cell fill is not changing). Not sure what I'm doing wrong here. submitted by /u/Mk1Racer25 [link] [comments]
Tagged with
#rows.com#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#Excel compatibility#row zero#financial modeling with spreadsheets#Excel alternatives#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#formatting#cells#conditional formatting