Forum Discussion
JoeCavasin
Oct 11, 2020Brass Contributor
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...
JMB17
Oct 13, 2020Bronze Contributor
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.
JoeCavasin
Oct 13, 2020Brass Contributor
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.