Using Excel 2013
I have two columns in my spreadsheet (E,F) that contain H,M or L. I want to highlight both columns depending on the combination of values. . At the moment, I am trying to highlight both columns as Amber if either of the columns contains "H".
The first two columns in the table below show the value in my sheet.
Column 3 shows the result using the formula =($E2="H")+($F2="H")>0 :X=Highlighted
I get the same results for =OR(($E2="H"),($F2="H"))
If I paste the formulae into the spreadsheet I get "True" and "False" as expected - so I haven't got anything strange in columns E and F
Can anyone tell me what I'm doing wrong and/or suggest a way to get the highlighting I want? I'm rapidly losing my mind.
<tbody>
</tbody>
I have two columns in my spreadsheet (E,F) that contain H,M or L. I want to highlight both columns depending on the combination of values. . At the moment, I am trying to highlight both columns as Amber if either of the columns contains "H".
The first two columns in the table below show the value in my sheet.
Column 3 shows the result using the formula =($E2="H")+($F2="H")>0 :X=Highlighted
I get the same results for =OR(($E2="H"),($F2="H"))
If I paste the formulae into the spreadsheet I get "True" and "False" as expected - so I haven't got anything strange in columns E and F
Can anyone tell me what I'm doing wrong and/or suggest a way to get the highlighting I want? I'm rapidly losing my mind.
H | H | X |
H | M | X |
H | L | X |
M | H | |
M | M | |
M | L | X |
L | H | |
L | M | |
L | L | |
<tbody>
</tbody>