Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to create Conditional Formats that "grow" with copy/fill down.
I would like to set up 1 conditional format that will grow as I copy & paste.
All I've been able to do is copy the same over & over. I have tried to "paste special - format", but it didn't work. Example: Cell value is: equal to, $F$8, then Font is White. I would like to grow the "$F$8" as I copy & paste. Thanks for ANY help. |
#2
|
|||
|
|||
Try a formula like
=A1=$F$8:F8 -- HTH RP (remove nothere from the email address if mailing direct) "AliceNXLand" wrote in message ... I would like to set up 1 conditional format that will grow as I copy & paste. All I've been able to do is copy the same over & over. I have tried to "paste special - format", but it didn't work. Example: Cell value is: equal to, $F$8, then Font is White. I would like to grow the "$F$8" as I copy & paste. Thanks for ANY help. |
#3
|
|||
|
|||
Thanks Bob, but, I guess what I DIDN'T say that I should have is: I want the
format to look at the $F$8's Previous Cell and if it's equal, then make that cell White. Then I want to copy that and paste down so it will look at $F$9's Previous Cell next time, etc. I don't understand what your formula will accomplish.... sorry. Please help me understand. Thanks. "Bob Phillips" wrote: Try a formula like =A1=$F$8:F8 -- HTH RP (remove nothere from the email address if mailing direct) "AliceNXLand" wrote in message ... I would like to set up 1 conditional format that will grow as I copy & paste. All I've been able to do is copy the same over & over. I have tried to "paste special - format", but it didn't work. Example: Cell value is: equal to, $F$8, then Font is White. I would like to grow the "$F$8" as I copy & paste. Thanks for ANY help. |
#4
|
|||
|
|||
Use $F8 instead of $F$8 then the format will copy down
-- Regards, Peo Sjoblom "AliceNXLand" wrote in message ... Thanks Bob, but, I guess what I DIDN'T say that I should have is: I want the format to look at the $F$8's Previous Cell and if it's equal, then make that cell White. Then I want to copy that and paste down so it will look at $F$9's Previous Cell next time, etc. I don't understand what your formula will accomplish.... sorry. Please help me understand. Thanks. "Bob Phillips" wrote: Try a formula like =A1=$F$8:F8 -- HTH RP (remove nothere from the email address if mailing direct) "AliceNXLand" wrote in message ... I would like to set up 1 conditional format that will grow as I copy & paste. All I've been able to do is copy the same over & over. I have tried to "paste special - format", but it didn't work. Example: Cell value is: equal to, $F$8, then Font is White. I would like to grow the "$F$8" as I copy & paste. Thanks for ANY help. |
#5
|
|||
|
|||
THANK YOU, THANK YOU, THANK YOU :-)
"Peo Sjoblom" wrote: Use $F8 instead of $F$8 then the format will copy down -- Regards, Peo Sjoblom "AliceNXLand" wrote in message ... Thanks Bob, but, I guess what I DIDN'T say that I should have is: I want the format to look at the $F$8's Previous Cell and if it's equal, then make that cell White. Then I want to copy that and paste down so it will look at $F$9's Previous Cell next time, etc. I don't understand what your formula will accomplish.... sorry. Please help me understand. Thanks. "Bob Phillips" wrote: Try a formula like =A1=$F$8:F8 -- HTH RP (remove nothere from the email address if mailing direct) "AliceNXLand" wrote in message ... I would like to set up 1 conditional format that will grow as I copy & paste. All I've been able to do is copy the same over & over. I have tried to "paste special - format", but it didn't work. Example: Cell value is: equal to, $F$8, then Font is White. I would like to grow the "$F$8" as I copy & paste. Thanks for ANY help. |
#6
|
|||
|
|||
Alice
Try removing the $ sign from $F$8 to read $F8 Gord Dibben Excel MVP On Wed, 20 Apr 2005 07:13:03 -0700, "AliceNXLand" wrote: Thanks Bob, but, I guess what I DIDN'T say that I should have is: I want the format to look at the $F$8's Previous Cell and if it's equal, then make that cell White. Then I want to copy that and paste down so it will look at $F$9's Previous Cell next time, etc. I don't understand what your formula will accomplish.... sorry. Please help me understand. Thanks. "Bob Phillips" wrote: Try a formula like =A1=$F$8:F8 -- HTH RP (remove nothere from the email address if mailing direct) "AliceNXLand" wrote in message ... I would like to set up 1 conditional format that will grow as I copy & paste. All I've been able to do is copy the same over & over. I have tried to "paste special - format", but it didn't work. Example: Cell value is: equal to, $F$8, then Font is White. I would like to grow the "$F$8" as I copy & paste. Thanks for ANY help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel conditional formats | Excel Discussion (Misc queries) | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
how do i get more than three conditional formats in excel | Excel Worksheet Functions | |||
Conditional Formats in Excel | Excel Worksheet Functions |