Changing the color of cells by formula

  • Thread starter Thread starter Emerogork
  • Start date Start date
E

Emerogork

I wish to change the colors of cells relative to values in other cells in the
same row. This is to be done automatically by formula. Can this be done?
 
You will have to use Conditional formatting (on the Format menu) with
the Formula Is option rather than Cell Contents Is. In XL 2003 and
earlier you are limited to 3 conditional formats per cell.

Hope this helps.

Pete
 

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

Excel VBA 1
Is there a way to change the color 3
How to Color a Cell Based on a Range of Cells with Colors 1
Changing Color of the Cell under Certain Conditions 8
Conditional Formatting Amendment 2
Counting by color 3
Conditional Formatting Confusion 8
Formatting background colors 1

Back
Top