Some conditional formatting issues

[Swedishish]

Hi everyone. I'm a mid-level excel user familiar with a handful of advanced functions, running Excel via Office 2010 (v. 14....).

I need some help implementing a condition whereby a row with a cell beginning with a ">" is treated differently than a row containing a cell beginning with "<" or is blank.

Essentially I want to check the relation between values in the same row to the number beginning with either ">" or "<" and then highlight the row if any cells are greater than 125% of the values beginning with "<" or 25% lesser than values beginning with ">." Basically I want to check if measured outcomes are within 25% of stated goals.

Thanks for any help.

.Swedishish

 

[Special-K99]

Best post an example file.

You cant attach files on this forum.
Upload the file to an online storage site then place a link to it on this forum.

 

[V_Malkoti]

You can write formulas in conditional formatting to do that.

Select the entire table. Then go to Home (ribbon) -> Conditional Formatting -> New Rule. Select last option "Use a formula to determine which cells to format" and enter formula.
Assuming your column C has ">25%" and "<25%" text that you want to test. Create two rules, one for each formatting:

=LEFT($C2)=">"

and

=LEFT($C2)="<"


Make sure that column is anchored, i.e. write $C2 not just C2.

 

[Swedishish]

Thanks for the help! You guys are super fast. Playing around with the suggestions now with varying degrees of success.