•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formatting highlighted cells
Our take
Conditional formatting can enhance your Excel experience by visually flagging important data, making it more intuitive and engaging. In your case, you want to highlight cells in Column A based on the color applied to cells in the same row. This is a straightforward process that can significantly improve data visibility. By setting up a conditional formatting rule, you can ensure that when you highlight a cell, the corresponding entry in Column A reflects that color.
Hoping 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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting for highlighting cellsI have two very lengthy columns, let’s call them column A and column B. I need to highlight all of the cells in column B whose content does not appear in column A, but there are 80+ cells I’d have to check and it’d take me a really long time. I’m in no way an expert on excel but I do know I’d have to use conditional formatting, I just don’t know how to build the formula for this :( submitted by /u/Nandolvs [link] [comments]
- Highlight non-adjacent cells that have same content in three columnsHave worksheet with several columns and multiple rows where need to highlight cells that have same data as in other rows. Basically, if column A, B and G have identical information in rows 7 and 183, these cells will all highlight. Goal is to identify if the same sequence of data is present, in another row of the worksheet. I have used following formula previously: =Countifs($A$7:$A$319,$A7,$B$7:$B$319,$B7)=1 However, I now need to innclude data that also appears same in column G. Note: the data in each column is different, Example: Row: 7: Column A: ABCD, Column B: 1234, Column G: Foxy Row: 183: Column A: ABCD, Column B: 1234, Column G: Foxy This match would highlight, but if one data point differs, no match. Hope someone can help here... Thank you. submitted by /u/ThunderWarrior3 [link] [comments]
- Conditional Formatting to highlight time for 24 hours (different for each cell)I would like the cells to be highlighted in red if it exceeds 24 hours based on the time and date in the individual cell. It is a large data set and it is preferable to not amend the formula in each cell individually. For example, column L has the cells where I want the cells to be highlighted if they exceed 24 hours however each cell as a different time; L2 is Mar 20, 2026, 10:25:21 PM and L3 is Mar 20, 2026, 7:00:01 AM. The 24 hour mark for the each cell would vary. submitted by /u/Interesting_Low9324 [link] [comments]
- Conditional Formatting with another cell?Hi everyone! I'm trying to create a condition where depending on the value of two cells, it will change the fill of one of them. For example, If Cell A is < 10% AND Cell B is X, then Cell A will be green. If it is > 10% and Cell B is X, then Cell A is red. How would I go about doing this? submitted by /u/Educational-Bass-413 [link] [comments]
Tagged with
#Excel alternatives for data analysis#financial modeling with spreadsheets#generative AI for data analysis#natural language processing for spreadsheets#Excel compatibility#Excel alternatives#rows.com#big data management in spreadsheets#conversational data analysis#large dataset processing#row zero#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#conditional formatting#Excel