Select Case

[nitrox_guy]

I am running a private sub with the following in it and is based on a result of a calculation from 2 other cells

Please Login or Register  to view this content.

when data is in put in to two cells e.g "G15" & "H15" a calculation is done in a seperate cell "L15" that determines the level of risk e.g. Case "Low - Little or no risk presented, continue with control measures in place" then the private sub will change the format of the cell according to the code (this works perfectly fine). what i want is for the cell to revert back to its orginal state if the two cells are cleared (orginal stating being font colour white and font colorindex being white) this is so that #value is not visible to the user another problem is that the calcution in "L15" is changing numbers into text. if there is no date in "G15" or "H15" "L15" states #value

this is the code is based on this formula =IF(L15<=2,$O$26,IF(L15<=5,$O$27,IF(L15<=8,$O$28,IF(L15>=9,$O$29," "))))
any help would be greatly appreciated, thanks in advance

John

[contaminated]

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags, click here.