@XLD...what you told me is not about CF its just simply coloring the rows...its just you didnt understand clearly what i last posted..
@luke...thanks for that...i tried..but it only referred to D1...i selected the range but it did not automatically adjust to D2...D3..D4...it only stayed to D1...
hello, can you please help me on how to copy the CF i created for a row...to have same effect on other existing rows??? e.g. A1 to D1 if value of D1=1 all rows of A1 till D1 will be green, then..A2 to D2 if value of D2=1 all rows of A2 till D2 will be green and so on and so forth...
oh...almost near...its working on "A" and "V" but if letters are present the numbers before and after it is not summing up..for example: 10 10 A A 10 RESULT IS A, it must be 30.
hello, am new here and asking for your advice....am doing timesheet stuff and i wanted to generate a certain formula that goes like this --> IF cells A1 to F1 contains A or V display A or V if not sum the numbers within cells A1 to F1...i hope its clear please help!!!