format cell on other cell infromation

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

Guest

I want to change the format of a cell depending on another cell's number. I
am looking for something like this:
For CELL A2=IF(A1=1,set the fill color to red, set the fill color to green)

Can anybody tell me th function for this setting color or other Cell
properties?
 
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

Conditional Formatting 3
Excel VBA 1
Excel Macro to automatically go to the right of the last colored cell 0
Can RGB fill color be automated based on 3 cell values? 2
Change Color of cell 3
Apply color of one cell to other 2
How to filter rows data based on background color of individual cells 1
Dynamically setting CELL COLORS based on TWO OTHER cell values 4

Back
Top