I have already posted a similar question, but I am changing my approach to the problem. I am working on a structural engineering spreadsheet. I have created two custom formats #" Wind" and #" Seismic". Column D contains seismic loads, Column E contains wind loads. I have a column full of formulae:
Cell F56 contains =max(D56+D11,E56+E11)
Cell F57 contains =max (D57+D12,E57+E12)
Cell F58 contains =max (D58+D13,E58+E13)
etc., etc.....

The formula add forces to those at stories above and determines which type of load is larger.

I am working in column F and I need to apply a conditional format based on what the formula spits out.
I want to format it such that if the value derived in the cell is D56+D11 then it applies #" Seismic" and if the value derived in the cell is E56+E11 then it applies #" Wind".

I also need a proper way to apply this to several cells in the column. I need to apply this formatting to F56:F91.

As always I have spent an inordinate amount of time on one little minor thing