| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
| 2007 Colors - I want 2003 Colors | Excel Discussion (Misc queries) | |||
| Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
| Forumla Help | Excel Discussion (Misc queries) | |||
| Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
Linear Mode
