Highlight Negative number cells

[xdave]

Hi,

im new to Macros,vba, and excel in general.
i have done some research and managed to get a few useful macros working. now im stuck finding a macro that will highlight negative cells in say column "L", and also highlight cells in column "V" with a value of less than 1.
Thanks in advance for any help you might be able to offer.

Dave.

 

[Boller]

Have a go at doing it with Conditional Formatting (and record it via the macro recorder if you need a macro).

 

[xdave]

like i said im new to this, the only macros i have made are via the record function.

 

[shadow12345]

Not sure if you know how to use condtional formating from your response, but if not this was pretty helpful to me

http://www.contextures.com/xlcondformat02.html

(if its not the right version of excel for you then google it)

 

[xdave]

The Conditional formatting worked for my first column where i need it to fill cells less than 0, but for my 2nd column where i need it to fill cells less than 1 i get a problem, it also fills blank cells continually through the whole column

 

[T. Valko]

The Conditional formatting worked for my first column where i need it to fill cells less than 0, but for my 2nd column where i need it to fill cells less than 1 i get a problem, it also fills blank cells continually through the whole column

What version of Excel are you using?

 

[xdave]

2007, it seems to be recongnising a blank cell as a number between 1 and 0, because just doing below zero i dont have the problem.

 

[T. Valko]

2007, it seems to be recongnising a blank cell as a number between 1 and 0, because just doing below zero i dont have the problem.

An empty cell will evaluate as 0 so you have to tell it to ignore the empty cells.

Try this...

Let's assume the range to format is V2:V10.

Select the *entire* range V2:V10 starting from cell V2.
Cell V2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

• Goto the Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a formula to determine which cells to format
• Enter this formula in the box below:
  =AND(V2<>"",V2<1)
• Click the Format button
• Select the desired style(s)
• OK out