Excel fill automatic fill in cell

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Onor said:
*does anybody know on how to set a formula to fill the cell with
specific
colour ? *
Click to expand...


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