CF

[Workbook]

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?

 

[T. Valko]

Try this:

For Excel versions 2003 and prior

Select the range of cells, A4:H4
Goto the menu Format>Conditional 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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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

 

[CTEagle91]

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]

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.

 

[Workbook]

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]

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