Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating
how can I have a cell change color if a cell within a group has the value of
"1" and then revert back it the value changes. A3 (Cell to change color) B1:E10 need to see if any cell returnes "1" if so need to change A3 to a color Else need to change it to another color. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating
Hi,
select A3 then format|Conditions format|Formula is paste in this formula =COUNTIF(B1:B10,1)0 Select a colour OK Mike "Albert Mulder" wrote: how can I have a cell change color if a cell within a group has the value of "1" and then revert back it the value changes. A3 (Cell to change color) B1:E10 need to see if any cell returnes "1" if so need to change A3 to a color Else need to change it to another color. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating | Excel Discussion (Misc queries) | |||
conditional formating | Excel Discussion (Misc queries) | |||
conditional formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Programming |