Thread: Two Conditions
View Single Post
  #5   Report Post  
Vacation's Over
 
Posts: n/a
Default

=T(B1) will return "" if no text is present otherwise it will return the text
so you can nest two if clauses:

=IF(T(B1)="",0,IF(A2=2,1,0))

returns 0 (false) unless both conditions are true then = 1 (true)

put this formula in the conditional formatting formula

"Xandlyn" wrote:

Okay I need help. Seems easy but I can't figure out the formula.

I want to have one cell change only when two specific conditions apply.

Example:
B2 will change color if B1=text and A2=2

Thank you!!