Excel question for beginner...

[Gregory]

My boss wants me to create a worksheet that will autofill cells a
particular color in response to the data entered ie if she types in
"run" in A1, A1 will autofill red. I am just learning this
program...help please???

 

[Guest]

Select the cells where this is supposed to happen.
Go to Format | Conditional Formatting.
Set it to Cell Value Equals
Type the Value in the Box Provided
Click the Format Button to set the necessary formatting

You may want to check out:
http://www.contextures.com/xlCondFormat01.html
for more information.

tj

 

[JulieD]

Hi Gregory

you can use conditional formatting for this as long as you don't have more
than 3 conditions. If you do you need to either check out other options
some are mentioned at the end of this email.

To apply conditional formatting:
1. select the cell(s)
2. choose format / conditional formatting from the menu
3. choose
cell value is
4. choose
equal to
5. type
run
6. click on FORMAT - set the formatting options that you want - font
colour is on the font tab, background colours on the patterns tab.
7. click OK
8. to add another condition click ADD and repeat steps 3 through 7

when you have finished click OK to return to the workbook.

Options for more than 3 conditional formats:
- John McGimpsey has an article on doing up to 6
www.mcgimpsey.com/excel/conditional6.html
- Bob Phillips & Frank Kabel have developed an excel add-in
www.xldynamic.com/source/xld.CFPlus.Downlaod.html
- or you can use some code in the worksheet_change event to do this too ..
if you're interested in this option and it isn't as difficult as it sounds
please post back.

Cheers
JulieD