View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default Formats in formulas

Hi

Use an UDF to return format value.


Arvi Laanemets


"Paul" wrote in message
...
Hey there,
is there any way in which logical test used in a formula could be, for
example,
"if(valueA=red text, value if true, value if false)"
or is there some other way in which the formatting of a value can
influence
output
Sort of like the opposite of conditional formatting?

Any help would be appreciated,
Paul :)