View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HROBERTSON HROBERTSON is offline
external usenet poster
 
Posts: 11
Default Formulas Based on Cell Format

Is there a way to write an if/then formula based on a cell's format. For
example, if cell A1 is red, then red? Any help, once again, would be greatly
appreciated.

Thank You!

A B C
1
2
3 =IF(A1=??red format??, "red", "white")