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?
|