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...
Having fixed that issue, the problem i'm having now is i need B7 to black out under two conditions:
1. cell B4 = "Coventry"
2. Cell B3 = "CHB" AND Cell B4 = "Kaiser"
This is currently written as: =OR($B$4="Coventry",AND($B$3="CHB",$B$4="Kaiser"))
It will only work (fill black) when cell B4 shows "Coventry". I've tried multiple versions, including two separate CF formulae, but of course nothing has yet worked.
Does anyone have any insight into how to make an evaluation statement like the above work for conditional formatting rules?
1. cell B4 = "Coventry"
2. Cell B3 = "CHB" AND Cell B4 = "Kaiser"
This is currently written as: =OR($B$4="Coventry",AND($B$3="CHB",$B$4="Kaiser"))
It will only work (fill black) when cell B4 shows "Coventry". I've tried multiple versions, including two separate CF formulae, but of course nothing has yet worked.
Does anyone have any insight into how to make an evaluation statement like the above work for conditional formatting rules?
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.