hello friends.
i am working on a huge excel sheet and need your help as i want to finish is ASAP and i want to save my time while working on it.
my question is:
>i have around 500 rows in range of cell a1 to a500
>each cell (a1-a500) contains some machines numbers
>each cell(a1-a500) is also having comments where details of that machine in provided i.e. machine full model/short name/vendor/service provider etc etc
>there are few lines which are important so i want to change colour in those lines. (like machine model, code, location)
> i want line 1 in red colour and bold - line 3 in red colour - line 5 in red
it hard to do it manually for all 500 rows. so creating a keyboard-macro. but its changing all comments in red and bold.
need your help to finish it fast, pls.
thanks
i am working on a huge excel sheet and need your help as i want to finish is ASAP and i want to save my time while working on it.
my question is:
>i have around 500 rows in range of cell a1 to a500
>each cell (a1-a500) contains some machines numbers
>each cell(a1-a500) is also having comments where details of that machine in provided i.e. machine full model/short name/vendor/service provider etc etc
>there are few lines which are important so i want to change colour in those lines. (like machine model, code, location)
> i want line 1 in red colour and bold - line 3 in red colour - line 5 in red
it hard to do it manually for all 500 rows. so creating a keyboard-macro. but its changing all comments in red and bold.
need your help to finish it fast, pls.
thanks
