I've tried the Macro above, but for some reason, when I run it, all it does is to underline the cells selected, even though the ones in my range are not underlined. On the other hand, if I select the entire range and apply Conditional Formatting, Excel calculates the duplicates in the whole range, which isn’t useful.Īnother user suggested using the below Macro, but it isn’t working: Sub NewCF() How do I apply conditional formatting to an entire row based on multiple cells Select the entire dataset (A2:F17 in this example). Select Highlight Cells Rules, then choose the rule that applies to your needs. However, I have 400 rows and it will take too long to select each row individually and set the Conditional Formatting. Highlight the cell in the row that indicates inventory, our Units in Stock column. Here I want both 5 to be highlighted, but not the 2s because they are in different rows. I want to get Excel, for each respondent, to highlight cells if there are repeated values. Each row has about 4 columns, and each cell contains a numeric value. I have a spreadsheet with approx 300 rows.
0 kommentar(er)
