Hi Guys , Seeking your help and advise for the current issue im facing. I'm trying to set the whole row with condition formatting base on a certain value in the column A.
I tried to use formula (=A2="Quotation ") with condition formatting but it only auto change the color in column A but not A,B,C,D
Below is the data i have
EG: If it is quotation then A,B,C,D will auto turn to blue.
A B C D
Data Group Sent Date Aged Status
Quotation 06/06/14 37 Open
Invoice 07/11/14 2 Open
invoice 05/01/14 73 Open
PO 07/01/14 12 Open
PO 07/05/14 8 Open
SO 06/30/14 13 Open
Quotation 05/18/14 56 Open
SO 05/05/14 69 Open
Cash Note 07/03/14 10 Close
Bookmarks