NPrinting Excel Report: Conditional Formatting

[d_ankusha]

Hi,

I have a column in my Excel sheet on which I want to apply Conditional formatting. I am able to do it if the values is negative or positive. But now the challenge is that I have to compare the value with another number.

For Example: I have a column named PR. If PR>.375 the value should be displayed in Green color otherwise red.

Can anyone help me with this issue?

[vamsee · Accepted solution]

Hello,

Highlight the column

1. Navigate to conditional formatting
2. Highlight Cell Rules
3. More Rules
4. Format only cells that Contain
5. Cell Value --> Greater Than --> 0.375
6. Format --> Fill --> Add your color
7. Repeat the above steps for <0.375

Thanks.