Oh!Calcutta
New Member
- Joined
- Jun 15, 2011
- Messages
- 26
Hello All!
Please help me in solving my problem.
I have a data set as follows:
Col A = Customer ID
Col B = Customer Name
Col C = Customer Address
Col D = Customer ZIP / PIN
Col E = Invoice / Bill Value
Col F = Tax Amount
Col G = Total of Invoice Value + Tax Amount
I want to present my data as:
(a) when Col E is negative, then the entire row say as red;
(b) when Col F is "0" (zero), then the entire row say as yellow;
(c) when Col G is less than $50,000, then the entire row say as light blue;
(d) when Col G is more than/equal to $50,000, then entire row say as green
Please help.
Thnx in advance.
Oh!Calcutta
Please help me in solving my problem.
I have a data set as follows:
Col A = Customer ID
Col B = Customer Name
Col C = Customer Address
Col D = Customer ZIP / PIN
Col E = Invoice / Bill Value
Col F = Tax Amount
Col G = Total of Invoice Value + Tax Amount
I want to present my data as:
(a) when Col E is negative, then the entire row say as red;
(b) when Col F is "0" (zero), then the entire row say as yellow;
(c) when Col G is less than $50,000, then the entire row say as light blue;
(d) when Col G is more than/equal to $50,000, then entire row say as green
Please help.
Thnx in advance.
Oh!Calcutta