Excel fill automatic fill in cell

[Guest]

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

 

[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

 

[eddie1]

*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

 

[Don Guillett]

Have a look at format>conditional formatting

 

[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