Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Can I conditional format a cell with color if the cell has a formula?
If yes, please advise. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Dan,
Yes, that is what it is for :-) Read more here http://www.contextures.com/xlCondFormat01.html -- Allllen "dan" wrote: Can I conditional format a cell with color if the cell has a formula? If yes, please advise. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Hi, Allen
I meant that if cell G2 has a formula i.e. Formula is =HASFORMULA(G2) simular to Formula is =ISERROR(C2) Thanks "Allllen" wrote in message ... Dan, Yes, that is what it is for :-) Read more here http://www.contextures.com/xlCondFormat01.html -- Allllen "dan" wrote: Can I conditional format a cell with color if the cell has a formula? If yes, please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |