•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting not highlighting selected cells when keyword is typed into a cell range unless it’s the first cell of the range
Our take
If you’re managing housekeeping assignments, you know the challenge of visualizing coverage in your spreadsheet. You want conditional formatting to highlight cells based on selection, but it only works when the keyword is in the first cell of your range. This limitation can hinder your team’s efficiency and clarity. In this guide, we’ll explore a solution that enables effective conditional formatting across your desired range, ensuring all assigned sections are clearly marked. Let’s transform your spreadsheet into a powerful tool for seamless operations!
Hello everyone!
I’m working on a project for work and I’m running into an issue that I can’t solve.
I work for housekeeping at a large property and we will, from time to time, shuffle around housekeepers and move their areas. I’m trying to use conditional formatting to highlight cells that resemble the different areas the housekeepers can be assigned as green once someone assigns that section to a housekeeper so they know the area is covered.
So far, I’ve tried using =[Range of Cells that has a Data Validation drop list of different sections]={Name of Section from Data Validation Table} with the “Apply To” range being 4 cells several columns over from the Section Selection range.
The group of cells will only highlight when the Section name is in the first cell of the range but no others.
Any help would be greatly appreciated!
[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]
- Why is my Custom Conditional Formatting not working?So I am trying to highlight green a spreadsheet of House information. I want all houses that have 3 bedrooms and 2 bathrooms to be highlighted green. The bedroom data starts from E2 and the bathroom data starts from F2 So I have used this exact formula =AND($E2=3, $F2=2) and selected the cells that return this data to be highlighted green with bold text. But when I click okay on the custom conditional formatting rule nothing happens. Nothing is highlighted green although I clearly see houses that meet my ‘highlight green’ criteria on the spreadsheet. Please help me out, what do I do? submitted by /u/bucks800 [link] [comments]
- Conditional formatting based on a range of text in 2nd sheetHey! I have a two sheet workbook. First sheet has column A: list of order numbers that should be highlighted based on status and column B: status. the status text comes from a list in the second sheet. all possible statuses are listed from A1:A10 on the second sheet, but there might select colors per status (like from A1:A3 and A10 would all need the same color) Right now I have as a formula: =$B1='Sheet2!A1 and that works, but trying to use a range doesn't work =$B1='Sheet2!$A1:$A$5 I'm certain I'm overlooking a basic issue, but my googling skills are failing me 😞 submitted by /u/jaegerjockey [link] [comments]
- How to stop data in new cells from inheriting formatting from previous rows?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. submitted by /u/StandardWriting3069 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#intelligent data visualization#rows.com#Excel compatibility#large dataset processing#financial modeling with spreadsheets#Conditional Formatting#highlighting#housekeeping#cells#Data Validation#sections#section name#apply to range#cell range