Conditional formatting does not function properly

**kelwood** · 09-06-2012, 10:52 AM

Greetings All,

Since my last post I have been rather capable of rectifying my code to get the desired result. However, I cannot seem to get this piece of code to work. It is supposed to format the cell and font colors based on the data in the cell. I will post the code I am using in the hope that someone plugs it in and finds my mistake.

Please Login or Register  to view this content.

**Special-K** · 09-06-2012, 11:09 AM

Long time programmer of 25 years but am no VBA expert.

"...ElseIf cell < 17 > 0 Then..."
Are you sure you can say that?

Shouldn't this be something like

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**kelwood** · 09-06-2012, 12:27 PM

Thank you very much for pulling my head out! Knew it was something stupidly easy.

**jeffreybrown** · 09-06-2012, 12:29 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save