excel - Is it possible to format cell color directly from the formula line? -


I know how it uses conditional formatting and VBA, but I was curious if it was straightforward Can be done by line. For example, I have a field in column H, which is "valid" or "invalid" , and the row based on the red or green color ( To ensure this, such as

 , (H2 = "valid"), A2: H2 (color = green), A2: HBOllore = red))    

This is not possible.

You need to use conditional formatting or VBA.

Comments