Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF
I am trying to set up conditional formatting so that if a 1 appears in Cell
O4 of Sheet 1, than A4:H4 from Sheet 1 will turn green. Is that possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF
Try this:
For Excel versions 2003 and prior Select the range of cells, A4:H4 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =$O$4=1 Click the Format button Select the desired style(s) OK out For Excel 2007: Select the range of cells, A4:H4 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =$O$4=1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Workbook" wrote in message ... I am trying to set up conditional formatting so that if a 1 appears in Cell O4 of Sheet 1, than A4:H4 from Sheet 1 will turn green. Is that possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF
Biff - I keep getting errors when I click the "Post" button, so I'll try one
more time on THIS thread just to make sure you get the message: THANK YOU VERY MUCH... it worked! "T. Valko" wrote: Try this: For Excel versions 2003 and prior Select the range of cells, A4:H4 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =$O$4=1 Click the Format button Select the desired style(s) OK out For Excel 2007: Select the range of cells, A4:H4 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =$O$4=1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Workbook" wrote in message ... I am trying to set up conditional formatting so that if a 1 appears in Cell O4 of Sheet 1, than A4:H4 from Sheet 1 will turn green. Is that possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF
Yeah, the web interface for the newsgroups has been screwed up for a few
days now. Thanks for going the extra mile in letting me know your question was solved. -- Biff Microsoft Excel MVP "CTEagle91" wrote in message ... Biff - I keep getting errors when I click the "Post" button, so I'll try one more time on THIS thread just to make sure you get the message: THANK YOU VERY MUCH... it worked! "T. Valko" wrote: Try this: For Excel versions 2003 and prior Select the range of cells, A4:H4 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =$O$4=1 Click the Format button Select the desired style(s) OK out For Excel 2007: Select the range of cells, A4:H4 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =$O$4=1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Workbook" wrote in message ... I am trying to set up conditional formatting so that if a 1 appears in Cell O4 of Sheet 1, than A4:H4 from Sheet 1 will turn green. Is that possible? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF
Awesome. It works great. I have one more question now. I have 6 conditions
but, as I am sure you know conditional formatting only has space for 3 conditions. Is there something I can do to the formula or something else to include the extra 3 conditions? =$O$4=1 =$O$4=2 =$O$4=3 =$O$4=4 =$O$4=5 =$O$4=6 "T. Valko" wrote: Try this: For Excel versions 2003 and prior Select the range of cells, A4:H4 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =$O$4=1 Click the Format button Select the desired style(s) OK out For Excel 2007: Select the range of cells, A4:H4 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =$O$4=1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Workbook" wrote in message ... I am trying to set up conditional formatting so that if a 1 appears in Cell O4 of Sheet 1, than A4:H4 from Sheet 1 will turn green. Is that possible? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CF
If you're using Excel 2007 you can have as many conditions as you want
(limited by system resources: memory). Otherwise, you'll need an event macro to do this. Or, there is a free add-in available that allows up to 30 conditions. See this: http://xldynamic.com/source/xld.CFPlus.Download.html -- Biff Microsoft Excel MVP "Workbook" wrote in message ... Awesome. It works great. I have one more question now. I have 6 conditions but, as I am sure you know conditional formatting only has space for 3 conditions. Is there something I can do to the formula or something else to include the extra 3 conditions? =$O$4=1 =$O$4=2 =$O$4=3 =$O$4=4 =$O$4=5 =$O$4=6 "T. Valko" wrote: Try this: For Excel versions 2003 and prior Select the range of cells, A4:H4 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =$O$4=1 Click the Format button Select the desired style(s) OK out For Excel 2007: Select the range of cells, A4:H4 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =$O$4=1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Workbook" wrote in message ... I am trying to set up conditional formatting so that if a 1 appears in Cell O4 of Sheet 1, than A4:H4 from Sheet 1 will turn green. Is that possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|