=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!!
|