Forum Discussion
Office Space Ranking System using formulas
I am trying to develop a spreadsheet that will flag users if they warrant a single or shared office space, attached is a rough start I have going. I am running into 2 main problems: 1. How to ge...
Follow up question, I was able to get some of your formulas working. Some I was able to reuse an old one. However in Column L I cannot figure out how to conditional format the "Current Space" to highlight based on the data in Column K.
Basically:
if No = Single then flag
No = Shared
Yes = Single
If Yes = Shared then flag
I have tried if/Then formulas but kept getting errors.
Please see the amended
This is the formula for the conditional:
=OR(AND($K2="No",$L2="Single"),AND($K2="Yes",$L2="Shared"))