Oct 11 2020 12:22 PM
Evening all, attaching a sample file with the formulas i already have for referencing other tabs, data pull in, data validation, etc. This is a calculator to assist my team in determining expected reimbursement. My current issue is just conditional formatting - i want two cells to turn black if two other cells don't contain certain info, and I want four other cells to turn black if certain info is present. The sheet gives all the details to make it simpler to follow. I have tried multiple attempts at correcting this, but somehow conditional formatting is kicking my butt...
Oct 11 2020 12:32 PM
Oct 11 2020 12:42 PM
Thanks JMB17, but if you click into any of the range B7:B10, you can see the CF formula still references the intended cells. In the snapshot below i've selected cell B8, and see the appropriate B4 and B3 references in the selection criteria. I would assume the remainder of B8-B10 would also fill black given that? Is there some other part to locking the reference i'm misunderstanding?
Oct 11 2020 08:02 PM
Oct 12 2020 04:38 PM
Oct 12 2020 09:31 PM
Oct 13 2020 04:04 AM
@JMB17 I'm certain no trailing or leading spaces. Unless there's some issue resulting from the values in B3 and B4 being selected by means of data validation drop down lists?
Attaching an updated copy.
Oct 13 2020 07:18 AM
I didn't see any data validation in the file using the formula you noted. Also, Coventry and Kaiser were not included as data validation options. So, I won't be able to say why it didn't work for you.
I added Coventry and Kaiser to the data validation list and copy/pasted your formula exactly as you have it into the data validation manager and it appears to work as intended.