can you use colors when creating forumla?

  • Thread starter Thread starter Ms_M_o_n_i_c_a
  • Start date Start date
M

Ms_M_o_n_i_c_a

example: i want cell a2 to highlite green if a1 is equal to 1

conditional formatting only works for one cell.
 
Which version of Excel are you using? In 2007, click in cell A2. In the
Conditional Formatting dialog box, click the last choice: Use a formula to
determine which cells to format. Type: =$A$1=1

Click the Format button and choose a color. Click OK

I don't know if this can be done in earlier versions.
 

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
SUMCOLOR with conditional formatting not working 3
Conditional Formatting Applying Rule to Entire Column 2
Questions on using conditional formatting 2
Conditional Formatting Dates 1
conditional formatting in excel 2007 1
A formula to type 1 in B2 if A2 has the color green? 1
Finding the vaule of a cell's fill color 1

Back
Top