Thread: Formula if a conditional format exists
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Formula if a conditional format exists
=IF(A1=0,1)

The same condition applies
--
Gary''s Student


"Shu of AZ" wrote:

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