Conditional Formatting???

  • Thread starter Thread starter Tom K
  • Start date Start date
T

Tom K

When I have a formula entered in a cell I want the back ground to chang
to a color. How do I do that with conditional formatting or is there
different way? I don't want it to change because of any particula
varibles I just want it to simply change color if a formula i
entered.

Thanks,
To
 
Tom said:
*When I have a formula entered in a cell I want the back ground t
change to a color. How do I do that with conditional formatting or i
there a different way? I don't want it to change because of an
particular varibles I just want it to simply change color if
formula is entered.

Thanks,
Tom *
Click to expand...
HI Tom,
Just follow conditional formating wizard. In the window put in th
condition and click the format key and pick color for the cell. It i
pretty simple.
Sazi
 
I know how to do it for a specific reason e.g. something over or under
50%, 1000 or whatever. I need to know how to do it for just a formula


I want to open the spreadsheet and have every single cell that has
formula in it to have a grey background, not because it's over
certain percentage or dollar amount.

My criteria is...if it has a formula change the cell to grey.

Sounds simple but sometime it's the simpleist thing that can stump you
 
One way to identify the cells with formulas is:
When you open a sheet, Press F5 (Goto), select Special and choos
formulas. This will highlight all cells containing formulas. You ca
then format cells and color them gray.

To make this automatic, I guess you would have to write a macro to d
the above and set it to run automatically whenever you open a workbook
 
Tom said:
*I know how to do it for a specific reason e.g. something over o
under 50%, 1000 or whatever. I need to know how to do it for just
formula.

I want to open the spreadsheet and have every single cell that has
formula in it to have a grey background, not because it's over
certain percentage or dollar amount.

My criteria is...if it has a formula change the cell to grey.

Sounds simple but sometime it's the simpleist thing that can stum
you. *
Click to expand...

Hi Tom,
Try this:

Sheets("Sheet1").Select

Range("A1").Select

If A1 = IsNonText Then
With Selection.Interior
.ColorIndex = 15
.Pattern = xlSolid

End With
End If
End Sub

This whould work
Sazi
 
Back
Top