Hi,

You can do that with conditional formatting. Set a conditional format of
cell value is 1 and select a colour, format the cell as percentage

Mike

"Confused Rookie" wrote:

I'm doing a simple % calculation. If the returned % is greater than 100%, I
want the % to be displayed in red so it's noticable. Otherwise I just want
the % displayed in black font. Can this be done?