I have a spreadsheet with tons of conditional formatting underlying in several cells. I don't know if it is possible what I want to do, which is
either of the following IF formulas apply.
IF(N557="pending","X","R/P")
(IF(N557="expected","X","X") ... but the word "expected" is followed by a date/word, i.e. the following items vary, the only constant is the word "expected"
I'm wondering, how to put both IF's in the cell, i.e. either applies, but how to write that cell N557 "contains" the word EXPECTED?
FYI: I cannot use date only, because the cell will ultimately have a date, so the conditional formatting won't work using a date only instead of putting the word "expected" in front of it.
Maybe I'm throwing conditional formatting and formulas together, which may not work. But I appreciate any ideas!
Thanks so much in advance.
Bookmarks