Excel fill automatic fill in cell


Ad

Advertisements

J

JulieD

Hi

check out conditional formatting on the format menu

post back with slightly more details of what you want to achieve if you
can't get it to work.

Cheers
JulieD
 
E

eddie1

Onor said:
*does anybody know on how to set a formula to fill the cell with
specific
colour ? *


Maybe this can help you (change color in cell next to input one)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 3 Then
ThisRow = Target.Row
If Target.Formula > 100 Then
Range("D" & ThisRow).Interior.ColorIndex = 3
Else
Range("D" & ThisRow).Interior.ColorIndex = xlColorIndexNone
End If
End If
End Su
 
Ad

Advertisements

M

Max

You could do it with conditional formatting (CF) ..

Example:

Select col A
Click Formatting > Conditional Formatting
Make the settings under Condition 1:
Formula Is | =NOT(ISBLANK(A1))
Click Format button > Patterns tab > light green > OK
Click OK at the main dialog

Try entering something in any cell in col A
The fill color "light green" will appear in the cell

For more info, try Debra Dalgleish's nice coverage of CF:
http://www.contextures.com/xlCondFormat01.html
 

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

Top