Automatic Conditional Formatting
 

I would like to ask for your help guys whoever know how to create a formula
or a macro that can be automatically apply a conditional formatting.
I have more than 5000 data. Each data has two columns. What I want to do is
to automatically highlight the value greater that 0 (zero) on the second
column of the data.
Here is the example:
| DATA1 |
|SALE | STOCKS |

Hoping for your responce.
Thanks in advance.
Joey

Automatic Conditional Formatting
 

I assume that the Sales Vales in column and the Stocks in B Column. Now you
want to highlight the B Column cells based if the A Column value is greater
than 0 (Zero)

A Col B Col
Sale Stocks
2
8
0
20
0
32

For Applying the Conditional Formatting
Place the Cursor in B2 cell and hit Cntrl+Spacebar now the Total B Column
will be selected, keep in mind that the active cell should be B2 (Active cell
will have a white background after selection also)

Now goto FormatConditional FormattingFormula Is Paste the below formula
=$A20
Click Format and set the desired Font colour and background as per your
desire and give Ok twice. Thats It!

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"joey" wrote:

I would like to ask for your help guys whoever know how to create a formula
or a macro that can be automatically apply a conditional formatting.
I have more than 5000 data. Each data has two columns. What I want to do is
to automatically highlight the value greater that 0 (zero) on the second
column of the data.
Here is the example:
| DATA1 |
|SALE | STOCKS |

Hoping for your responce.
Thanks in advance.
Joey