conditional formatting
If *.33 are in formulas then Excel would have entered the .33 as 0.33.
On the Home tabEditing groupBinoculars iconReplace
Find what: ~*0.33
Replace with: enter what you wish to replace it with but don't enter the
tilde ~
Replace All
--
Biff
Microsoft Excel MVP
"Rene" wrote in message
...
Excellent! Can I find/replace all *.33? I know how to replace all text
and
formulas but don't know how to replace conditional formatting.
Thanks again.
"T. Valko" wrote:
You can apply the formatting in a single operation.
If your range to format is A2:Z2
Select the *entire* range A2:Z2 starting from cell A2. A2 will be the
active
cell. The active cell is the single cell in the selected range that *is
not
shaded*. The formula will be entered relative to the active cell. The
cell
references will automatically adjust for the other cells in the range.
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=A2A1*0.33
Click the Format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP
"Rene" wrote in message
...
Can you auto fill condtioning formatting in excel 2007? fill handle?
Looking to color code an indv cells across rows.
color code a2 if a2 a1*.33
a b c
1 200 100 50
2 25 50 10
200*.33=66 100*.33=33 50*.33=16
no color code color code no color code
25<66 5033 10<16
Or do I need to format each cell a2:z2...
Thanks
|