Color Code

  • Thread starter Thread starter Ali
  • Start date Start date
A

Ali

If the cell is a value turn red if its a formula turn the
cell blue.

Thanks in advance for your help.
 
On Error Resume Next
cells.SpecialCells(xlformulas).Interior.ColorIndex = 8 ' or 5 for dark
blue
cells.SpecialCells(xlConstants).Interior.ColorIndex = 3
On Error goto 0
 
Thank Tom!
-----Original Message-----
On Error Resume Next
cells.SpecialCells(xlformulas).Interior.ColorIndex = 8 ' or 5 for dark
blue
cells.SpecialCells(xlConstants).Interior.ColorIndex = 3
On Error goto 0
--
Regards,
Tom Ogilvy






.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use Conditinal Format for another cell? 1
Another VB Code Question 6
Conditional Formatting with VBA 4
Changing Cell Properties when sheet is protected 1
Conditional formatting based on numbers in columns 5
CountIf query for words within string 1
Formula for Conditional Formatting 16
Change Color of cell 3

Back
Top