Forum Discussion
Excel Highlight a row according to a change in a specific cell
am using Excel 2016 and i want an advice on how to do this: i have an excel table and i want to highlight each row basing on a change in a cell in row and change a color for example if c2,c3,c7 cont...
Let me give you a tip that would guide you..
* Select the range of data you want to be highlighted (don't include column headers)
* Open the conditional formatting dialog and add a new rule based on a formula.
*Make sure you find out your unique Values *
* =$c2,$c3,$c7 ="same value" (Based on certain criterias;
* Hit OK and change the formatting as desired.
* You can make another rule to handle the other color, or just create new rows filled with red for example; the conditional formatting will override the color based on your entry.
* Select the range of data you want to be highlighted (don't include column headers)
* Open the conditional formatting dialog and add a new rule based on a formula.
*Make sure you find out your unique Values *
* =$c2,$c3,$c7 ="same value" (Based on certain criterias;
* Hit OK and change the formatting as desired.
* You can make another rule to handle the other color, or just create new rows filled with red for example; the conditional formatting will override the color based on your entry.
thank you Donald_Genes but what to do in case all of these c2, c3, and other are many in a big excel sheet let say the values that are the same and are many how will i click on each of them to ad them in the formulas yet am not even sure how many are they
- Simple highlight all the range of Column that contains C2to whatever c10000 and use same logical Analysis.. Haven't seen the data to know what you really saying
This is the result i want to have
Based on Column A at every change a different color is applied to facilitate the reading of the table and its changes. currently the way i make this is that i highlight all row with the number 1510 and highlight it with a color and select another and apply a different highlight and this is will be very hard when am dealing with a large number of rows that i have to check especially when they are not sorted out.
If this is fix number of rows, like for year 1991 10 rows and for year 1992 10 rows then just simply add a column put 10 vakues of 1, then out 10 values of 2, copy these twenty cell and repeat under it, copy 40 now and paste..repeat till u r covering entire datw. filter 1 color it, filter 2 color it