Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional colour fill a row - based on cell value =100%
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional colour fill a row - based on cell value =100%
Greg --
Select the row by clicking the number on the left-hand side. Click FormatConditional Format. Change 'Cell Value Is' to 'Formula Is' and, in 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" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional colour fill a row - based on cell value =100%
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--- -- RyGuy "pdberger" wrote: Greg -- Select the row by clicking the number on the left-hand side. Click FormatConditional Format. Change 'Cell Value Is' to 'Formula Is' and, in 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" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif - I wish to add cells based on the font/fill colour | Excel Worksheet Functions | |||
Is there a way to add cells based on their shading / fill colour? | Excel Discussion (Misc queries) | |||
Sum contents of comments based on back fill colour | Excel Discussion (Misc queries) | |||
conditional fill colour | Excel Discussion (Misc queries) | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) |