If C2 > E2, copy cell H2 formatting

[brlattim]

I have a list. I want to copy a cells formatting if one cell is greater than the other. Is there anyway to do this? I tried conditional formatting, but the problem is I only want to change fill and text color. Some rows have different decimal requirements so conditional formatting (format painter) isn't working. I have tried conditional formatting, but it copies the entire format and not just the cell fill and text color that was part of the format rule. Can anyone help losing my mind over here

 

[rlv01]

Any post about copying that does not contain very specific information about where to copy from and where to paste to is difficult to answer.

If C2 > E2, copy cell H2 formatting

Copy to where, exactly?

 

[brlattim]

Apologies, copy H2 formatting to C2.

 

[rlv01]

So a VBA macro can probably do what you want, if VBA is something you are willing to include in the workbook. But before that you should probably consider what you want to happen if the condition is not met. Right now, you have stated the requirement that if C2 > E2, then copy cell H2 formatting to C2. But what happens if C2 <= E2? Do you leave the C2 formatting as is, or revert to something else?
An example: say that C2 > E2 and so running the macro changes the formatting to be the same as H2. Then 10 minutes from now you change the value of C2 so that it is LESS than E2. The format of C2 is already copied from H2. Do you want to leave it that way or change back to some other formatting?