Conditional Formatting

[Oh!Calcutta]

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

 

[etaf]

have a read here on how to format a row based on one cell value
How to Highlight a Row in Excel Using Conditional Formatting

then you just need the 4 conditions
assuming spreadsheet rows are upto 100 - change as required

select A2 : G100
goto conditional formatting
formula
enter
=$E2 < 0
format to the fill colour red
apply

next rule
=$F2=0

next rule
=$G2<50,000

next rule
=$G2>=50,000

apply and put in that order and click on stop if true - so that , negative , and zero , does get used with <50000

the $ stops the column changing as it applies to the other cells and so will highlight the row based on just the one cell in that rows condition

Note will not work with 2003 version as you can only have 3 conditional format formulas