can you use colors when creating forumla?

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.
 
G

Guy Lydig

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.
 
Top