Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
one cell's value Highlights selected cells....how?
Hi,
I know this is probably simple. But how can I get a range of cells hghlighted a different colour if one of those cells equals a certain value. Any help apprecited. Col |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
one cell's value Highlights selected cells....how?
Select the range in question,
from the main menu select format--conditional format, on the next screen in the 3 boxes select/type: Cell value is, equal to, 1, click format, select the formating option(s), click ok, click ok. Done Hans |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
one cell's value Highlights selected cells....how?
Hi Col,
If you want the whole range, say A1:A10, to change to the same colour when any of the cells in that range equal a certain value, say 42, the meaning of life if my memory serves me correct:-), then I think you have to use a formula in the conditional formatting of that range of cells.To do that (for A1:A10 and certain value = 42)... Select A1:A10 from the main menu select format--conditional format, on the next screen in the 2 boxes select/Formula Is: type this formula =NOT(ISERROR(LOOKUP(42,$A$1:$A$10))) click format, select the formating option(s), click ok, click ok. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding selected cells | New Users to Excel | |||
can't highlight cell - highlights only cell's row and column | Excel Discussion (Misc queries) | |||
moving mouse highlights cells without touching left mouse button | Excel Discussion (Misc queries) | |||
moving mouse highlights cells. why? | Excel Discussion (Misc queries) | |||
Selected cells grow and data entry impossible EXT is dissabled | Excel Discussion (Misc queries) |