| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I...
Dear all,
How do I do the following please... Cell A1 contains a number from 1 to 100. Cells B1-B100 (depending on nr in cell A1) will be filled with blue. i.e. if cell A1 contains the number 40, cells B1-B40 are all highlighted blue. Thanking-you in advance, Neil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I...
Have a look at Format | Conditional Formatting
Then come back if more help needed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Neil Pearce" wrote in message ... Dear all, How do I do the following please... Cell A1 contains a number from 1 to 100. Cells B1-B100 (depending on nr in cell A1) will be filled with blue. i.e. if cell A1 contains the number 40, cells B1-B40 are all highlighted blue. Thanking-you in advance, Neil |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I...
Nope, sorry, I've had a fiddle around and no luck.
"Bernard Liengme" wrote: Have a look at Format | Conditional Formatting Then come back if more help needed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Neil Pearce" wrote in message ... Dear all, How do I do the following please... Cell A1 contains a number from 1 to 100. Cells B1-B100 (depending on nr in cell A1) will be filled with blue. i.e. if cell A1 contains the number 40, cells B1-B40 are all highlighted blue. Thanking-you in advance, Neil |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I...
If I insert a number into column B cells, i.e. B1 "1", B2 "2", B3 "3"... then
conditionally format the column to fill blue "if less than or equal to $A$1" it works. However this means that the cells in column B are filled with numbers when I ideally wish to fill them for additional information. "Bernard Liengme" wrote: Have a look at Format | Conditional Formatting Then come back if more help needed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Neil Pearce" wrote in message ... Dear all, How do I do the following please... Cell A1 contains a number from 1 to 100. Cells B1-B100 (depending on nr in cell A1) will be filled with blue. i.e. if cell A1 contains the number 40, cells B1-B40 are all highlighted blue. Thanking-you in advance, Neil |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I...
In CF, use Formula Is, rather than Cell Value Is, and use the formula
=ROW()<=$A$1 -- David Biddulph "Neil Pearce" wrote in message ... If I insert a number into column B cells, i.e. B1 "1", B2 "2", B3 "3"... then conditionally format the column to fill blue "if less than or equal to $A$1" it works. However this means that the cells in column B are filled with numbers when I ideally wish to fill them for additional information. "Bernard Liengme" wrote: Have a look at Format | Conditional Formatting Then come back if more help needed best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Neil Pearce" wrote in message ... Dear all, How do I do the following please... Cell A1 contains a number from 1 to 100. Cells B1-B100 (depending on nr in cell A1) will be filled with blue. i.e. if cell A1 contains the number 40, cells B1-B40 are all highlighted blue. Thanking-you in advance, Neil |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I...
Clever.
Gord On Thu, 14 Feb 2008 19:58:32 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: In CF, use Formula Is, rather than Cell Value Is, and use the formula =ROW()<=$A$1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
