Menu
Is it possible in Excel to suppress values in a column when the cell above has the same value?
I want something like this :
A 1234
2345
3456
B 4567
C 5678
6789
D 7890
8901
where the 2 cells under A are actually A, but hidden.
Ideally I'd want this in some sort of formula, because the data comes from a mysql merge and it has to do this automatically...
529
To highlight cells based on another cell's value, you can create a custom formula within a conditional formatting rule. Select the range you want to apply formatting to. In the Ribbon, select Home > Conditional Formatting > New Rule.
Choose Settings for Less Than In the first box, type 50 -- we want to highlight numbers that are less than that number. In the second box, click the drop down arrow. Click on Light Red Fill. Click OK, to apply the Conditional Formatting to the selected cells.
This can be achieved with conditional formatting.
Assuming the data you want to hide is in Column A, for cell A2 set Conditional Formatting formula to =A2=A1 and format to Number, Custom, ;;; then copy format down the column
138
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
