View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joey Joey is offline
external usenet poster
 
Posts: 45
Default 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