Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting, copy for rows
Hi, I have a simple conditional format, where cell a1 goes red, if it
is less than a value in cell b1. If it is greater than or equal to it is green. The problem is I have 300 rows to do this on. I obviously dont want to go down all the rows putting the details in each time. If i copy and paste the conditional format the "cell value is" within the conditional format always remains as $b$1 when for row 2 the format in a2 should say b2, a3 say b3 etc etc. Is there a quick way top do this please? Cheers Rich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting, copy for rows
Select A1:A300, then in CF use a condition of Formula Is and a formula of
=A1<B1 for red and =A1=B1 for green -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richhall" wrote in message oups.com... Hi, I have a simple conditional format, where cell a1 goes red, if it is less than a value in cell b1. If it is greater than or equal to it is green. The problem is I have 300 rows to do this on. I obviously dont want to go down all the rows putting the details in each time. If i copy and paste the conditional format the "cell value is" within the conditional format always remains as $b$1 when for row 2 the format in a2 should say b2, a3 say b3 etc etc. Is there a quick way top do this please? Cheers Rich |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting, copy for rows
Take out the extraneus $ from the formula. If you are in B1 and are copying
down, it should look like $B1 "Richhall" wrote: Hi, I have a simple conditional format, where cell a1 goes red, if it is less than a value in cell b1. If it is greater than or equal to it is green. The problem is I have 300 rows to do this on. I obviously dont want to go down all the rows putting the details in each time. If i copy and paste the conditional format the "cell value is" within the conditional format always remains as $b$1 when for row 2 the format in a2 should say b2, a3 say b3 etc etc. Is there a quick way top do this please? Cheers Rich |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting, copy for rows
On 17 Apr, 19:25, "Bob Phillips" wrote:
Select A1:A300, then in CF use a condition of Formula Is and a formula of =A1<B1 for red and =A1=B1 for green -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Richhall" wrote in message oups.com... Hi, I have a simple conditional format, where cell a1 goes red, if it is less than a value in cell b1. If it is greater than or equal to it is green. The problem is I have 300 rows to do this on. I obviously dont want to go down all the rows putting the details in each time. If i copy and paste the conditional format the "cell value is" within the conditional format always remains as $b$1 when for row 2 the format in a2 should say b2, a3 say b3 etc etc. Is there a quick way top do this please? Cheers Rich- Hide quoted text - - Show quoted text - THanks thats brilliant. Didn't realise it was so simple! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Top 10 conditional formatting down 1000+ rows | Excel Worksheet Functions | |||
Copy Conditional Formatting? | Excel Discussion (Misc queries) | |||
Copy Conditional Formatting down rows | Excel Discussion (Misc queries) | |||
Conditional Formatting Copy down Rows | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) |