Automatic Conditional Formatting

  • Thread starter Thread starter joey
  • Start date Start date
J

joey

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
 
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 Format>>Conditional Formatting>>Formula Is>> Paste the below formula
=$A2>0
Click Format and set the desired Font colour and background as per your
desire and give Ok twice. That’s It!

Remember to Click Yes, if this post helps!
 
Back
Top