Thread: Formula if a conditional format exists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shu of AZ Shu of AZ is offline
external usenet poster
  
Posts: 130
Default Formula if a conditional format exists
If A1=1, and B1 has a conditional format that changes the color to red if A1
equals 1, what is the IF formula to change C1 to a zero if B1 is red.
Reply With QuoteReply With Quote