can you use colors when creating forumla?
 

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

conditional formatting only works for one cell.
--
I will Excel at Excel!

can you use colors when creating forumla?
 

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.

"Ms_M_o_n_i_c_a" wrote:

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

conditional formatting only works for one cell.
--
I will Excel at Excel!

can you use colors when creating forumla?
 

Yes, same in Excel earlier versions back to 97


Gord Dibben MS Excel MVP

On Sun, 3 Aug 2008 21:00:36 -0700, Guy Lydig
wrote:

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.

"Ms_M_o_n_i_c_a" wrote:

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

conditional formatting only works for one cell.
--
I will Excel at Excel!