Hoping someone could help:
If Cell B95 >=1 AND Cell D6 = B202 or B206 or B209 then Cell B22 font will turn red. Can this be in a conditional format?
Thanks!
Hoping someone could help:
If Cell B95 >=1 AND Cell D6 = B202 or B206 or B209 then Cell B22 font will turn red. Can this be in a conditional format?
Thanks!
Last edited by ExcelDummy77; 08-27-2014 at 09:51 AM.
Select B22 and use this formula in conditional formatting
=AND(B95>=1,OR(D6=B202,D6=B206,D6=B209))
choose format as required
all done
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks