View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frank Pytel Frank Pytel is offline
external usenet poster
 
Posts: 103
Default Test cell interior color by worksheet function?

=CELL("color",C6)

This is a volitale formula. It states that it works best with numbers for
calculations. I cant seem to get it to work with an if() statement.

Maybe you could come up with another qualifier. What are you basing your
conditional formatting on. If you were to use this as you qualifier it would
probably be easier to use in your calculations.

God Bless

Frank Pytel

http://groups.google.com/group/excel...mming?lnk=iggc

"Skimmer" wrote:

I'm trying to conditionally test a cell interior color, by worksheet function
(not VBA). I intend to use the responses to permit varied numerical
consequences... I've seen no Excel Help addressal on this, just on text
(contents) coloration.