Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the color of cells having formula.
Hi all,
Is it possible to change the color of the cells which has any type of formula? I have tried with conditional formatting but not succeeded with it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the color of cells having formula.
Edit Goto Special Formulas
Then set the format. -- Gary''s Student - gsnu200753 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the color of cells having formula.
Hi Arup,
I don't know of a way with CF but you can do it by tapping F5 click Special and check Formulas. This will highlight all your formulas and you can then set your formatting. You can also use Ctrl+` (the symbol to the left of 1 at the left of your keyboard. This is a toggle switch that will alternate between displaying the formulas and their values. HTH Martin "Arup C" wrote in message ... Hi all, Is it possible to change the color of the cells which has any type of formula? I have tried with conditional formatting but not succeeded with it. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the color of cells having formula.
Hi,
It was helpful though I was asking for the command which autometically detects any formula and changes color of the cell like the conditional formatting command "Gary''s Student" wrote: Edit Goto Special Formulas Then set the format. -- Gary''s Student - gsnu200753 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the color of cells having formula.
For a non-vba method try:
http://www.j-walk.com/ss/excel/usertips/tip045.htm "Arup C" wrote: Hi all, Is it possible to change the color of the cells which has any type of formula? I have tried with conditional formatting but not succeeded with it. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change the color of cells having formula.
You need to create a UDF
Function HasFormula(rng as range) If rng.Cells.Count = 1 Then HasFormula = rng.IsFormula End If End Sub and use that in the CF =HasFormula(A2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Arup C" wrote in message ... Hi, It was helpful though I was asking for the command which autometically detects any formula and changes color of the cell like the conditional formatting command "Gary''s Student" wrote: Edit Goto Special Formulas Then set the format. -- Gary''s Student - gsnu200753 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change color of already shaded cells | Excel Discussion (Misc queries) | |||
how do i change the selected cells color | New Users to Excel | |||
How to change cells color | Excel Discussion (Misc queries) | |||
Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
Change color in cells | Excel Discussion (Misc queries) |