View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Moreshwar Moreshwar is offline
external usenet poster
 
Posts: 1
Default values v formulas with conditional formats

On Monday, 20 May 2013 10:53:25 UTC+2, wrote:
None of the two solutions works for me!? I have Excel 2013 - is that the problem?


Try this ...

Step1 - Create a named formula
Select cell A1 (this is important!!!)
Formulas Name Manager New
Name: IsFormula
Refers to: =GET.CELL(48,A1)
OK

Step2 - Apply the formatting
Select the cell(s) you want to format.
Home Conditional Formatting Manage Rules New Rule
Select "Use a formula to determine which cells to format"
Enter this formula in the text box "Format values where this formula is true:
=IsFormula
Click the Format button
Select the desired style(s)
OK