hi,
how to highlight the excel cells based on value present in another column or same column. Example-
cola colb
25-Aug b
26-Aug c
27-Aug d
28-Aug e
29-Aug y
1. To highlight col b cells where col b does not contains text "d". So, rest all in col b to be highlighted.How to do this?
2. To highlight the col a cells where value in col a > current date. How to do this?
3. Where ever there is "e" written in col b, highlight the respective col A cell in yellow (28-Aug). How to do this?
how to highlight the excel cells based on value present in another column or same column. Example-
cola colb
25-Aug b
26-Aug c
27-Aug d
28-Aug e
29-Aug y
1. To highlight col b cells where col b does not contains text "d". So, rest all in col b to be highlighted.How to do this?
2. To highlight the col a cells where value in col a > current date. How to do this?
3. Where ever there is "e" written in col b, highlight the respective col A cell in yellow (28-Aug). How to do this?
Last edited: