conditional colour fill a row - based on cell value =100%

G

Greg

I am trying to format a row so as if a certain cell value on that row = 100%,
then the row will be colour filled a certain colour.
 
P

pdberger

Greg --

Select the row by clicking the number on the left-hand side. Click
Format>Conditional Format. Change 'Cell Value Is' to 'Formula Is' and, in
Click to expand...
the next field, type =$A$1=1. Replace the $A$1 with whatever your key cell
is. Then click the format buttons to format the cells the color you want,
and click OK.

HTH
 
Top