I need an IF formula or maybe even another logic formula value that will display one of two values (acceptable, unacceptable) if a cell had a set number of characters.
I have 4 cells that require the following:
Cell B1 requires 9 charachters
Cell B2 requires 16 characters
Cell B3 requires 20 characters
Cell B4 requires 10 characters
I want Cells C1 - C4 to display Acceptable or Unacceptable based on the amount of characters in cells B1 - B4 (if there are 5 characters in B1, C1 should display unacceptable)
Note: Can C1- C4 also contain a Conditional Format (when its acceptable the cell is green and if its unacceptable the cell is red, both with a white font for visibility).