G Greg Apr 29, 2008 #1 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.
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 Apr 29, 2008 #2 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
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
R ryguy7272 Apr 29, 2008 #3 Take a look at these when you get a chance: http://www.contextures.com/xlCondFormat01.html http://www.contextures.com/xlCondFormat03.html http://www.cpearson.com/excel/banding.htm Regards, Ryan---
Take a look at these when you get a chance: http://www.contextures.com/xlCondFormat01.html http://www.contextures.com/xlCondFormat03.html http://www.cpearson.com/excel/banding.htm Regards, Ryan---
