Forum Discussion
Excel Calculator with conditional format
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 r...
The formula looks good. Are you positive B3="CHB" and B4="Kaiser"? Are there any trailing spaces in those cell values?
If that's not the issue, you'll need to upload another copy of the workbook with the applicable worksheets.
If that's not the issue, you'll need to upload another copy of the workbook with the applicable worksheets.
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.
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.