changing property of a box while using if/then statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to change a boxes color and use a if statement . For example( if
k7>0 then change the boxes color red). Is this possiable or is their an
easier way.

Thanks for any help.

Mark
 
Hi Mark,

When you say boxes, do you mean cells? If you do mean cells then look up
Conditional Formatting.

If this doesn't help then get back to me and let me know the version of xl
you are using and I'll provide some further instructions.
 

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

change color of a box with using if statements 3
Change Shapes (countries in map) based on conditions 1
Conditional statement 1
Using VBA to change Excel layouts 2
Error 0xC00D3E8E: The property is read only. One way to fix. 1
Windows 7 Default page color for e-mail (Outlook) 1
Error Installing "ADAPTEC EZCD 4.04" 1
Ten Great Truths 2

Back
Top