Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic formatting | Excel Discussion (Misc queries) | |||
automatic formatting | Excel Worksheet Functions | |||
Automatic formatting help? | Excel Discussion (Misc queries) | |||
Display Automatic formatting | Excel Discussion (Misc queries) | |||
Automatic Row Formatting | Excel Discussion (Misc queries) |