Hi,

I am doing a sheet that needs a conditional formatting for a percent column.

I have one column.......List Price
Second column............Sell Price
Third column...............% of list price

Example:

A B C

1 List Price Selling Price Percent of List

2 725,000 645,250 89.0%

3 219,000 215,000 98.2%

4 285,700 300,000 105.0%


I need to format this so that if the % in Col C is higher than 98% it will apply a yellow fill to that cell.

Thanks.