In the attached sheet I'm trying to make a conditional format to state:
if D6 = B204,B206,orB207 AND cell B94 = to value of "1" then B22 is font color orange. Can this be applied in a conditional format?
Cell B94 is derived off of D7-C20 dates.
Attached is spreadsheet if needed.
Thanks.
Last edited by ExcelDummy77; 08-18-2014 at 01:07 PM.
I don't understand the question.
What has to happen in order for the cell to turn orange?
IF(D6=B204,B206,OR(B207,AND(B94)=1)) doesn't make sense!
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
I'm asking if a conditional format could be created for B22 based on an answer of D6 (the answers are from cells B204, B206 or B207) and if the Duration of Stay Cell B94 = 1.
How about:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
works perfect. thanks ConneXionLost!
May be apply the below and check it out
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
mm bit late on posting
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks