PDA

View Full Version : Solved: Conditional Formatting Based on Percentage



john3j
04-15-2009, 07:00 AM
Hello,

Can anyone help me figure out a formula that will turn a cell red if:

The percentage from I7/C7 is >= 90%

Thanks!

mdmackillop
04-15-2009, 11:09 AM
Use this as your conditional formatting formula
=$I$7/$C$7>=0.9