Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating in Excel
I would like a cell to change color when a range of other cells all have a
value entered. The cell I want to automatically format has the Sum function for a range of cells in it. When the range of cells that are being being used for the Sum function all have a value entered I would like the cell with the Sum to change either background color or font color. Is there an easy way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating in Excel
Let's assume A1 contains the formula =SUM(B1:B10)
Select cell A1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =COUNT(B1:B10)=ROWS(B1:B10) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Arne" wrote in message ... I would like a cell to change color when a range of other cells all have a value entered. The cell I want to automatically format has the Sum function for a range of cells in it. When the range of cells that are being being used for the Sum function all have a value entered I would like the cell with the Sum to change either background color or font color. Is there an easy way to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating in Excel
It didn't seem to work for me. Here is the formula in the cell I would like
to change the format of if all other cells have a value. =IF(SUM(Q4:AH4)=1,SUM(Q4:AH4),"") "T. Valko" wrote: Let's assume A1 contains the formula =SUM(B1:B10) Select cell A1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =COUNT(B1:B10)=ROWS(B1:B10) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Arne" wrote in message ... I would like a cell to change color when a range of other cells all have a value entered. The cell I want to automatically format has the Sum function for a range of cells in it. When the range of cells that are being being used for the Sum function all have a value entered I would like the cell with the Sum to change either background color or font color. Is there an easy way to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating in Excel
Ok, try this:
=COUNT(Q4:AH4)=COLUMNS(Q4:AH4) -- Biff Microsoft Excel MVP "Arne" wrote in message ... It didn't seem to work for me. Here is the formula in the cell I would like to change the format of if all other cells have a value. =IF(SUM(Q4:AH4)=1,SUM(Q4:AH4),"") "T. Valko" wrote: Let's assume A1 contains the formula =SUM(B1:B10) Select cell A1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =COUNT(B1:B10)=ROWS(B1:B10) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Arne" wrote in message ... I would like a cell to change color when a range of other cells all have a value entered. The cell I want to automatically format has the Sum function for a range of cells in it. When the range of cells that are being being used for the Sum function all have a value entered I would like the cell with the Sum to change either background color or font color. Is there an easy way to do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating in Excel
That works, Thanks a lot.
"T. Valko" wrote: Ok, try this: =COUNT(Q4:AH4)=COLUMNS(Q4:AH4) -- Biff Microsoft Excel MVP "Arne" wrote in message ... It didn't seem to work for me. Here is the formula in the cell I would like to change the format of if all other cells have a value. =IF(SUM(Q4:AH4)=1,SUM(Q4:AH4),"") "T. Valko" wrote: Let's assume A1 contains the formula =SUM(B1:B10) Select cell A1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =COUNT(B1:B10)=ROWS(B1:B10) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Arne" wrote in message ... I would like a cell to change color when a range of other cells all have a value entered. The cell I want to automatically format has the Sum function for a range of cells in it. When the range of cells that are being being used for the Sum function all have a value entered I would like the cell with the Sum to change either background color or font color. Is there an easy way to do this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating in Excel
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Arne" wrote in message ... That works, Thanks a lot. "T. Valko" wrote: Ok, try this: =COUNT(Q4:AH4)=COLUMNS(Q4:AH4) -- Biff Microsoft Excel MVP "Arne" wrote in message ... It didn't seem to work for me. Here is the formula in the cell I would like to change the format of if all other cells have a value. =IF(SUM(Q4:AH4)=1,SUM(Q4:AH4),"") "T. Valko" wrote: Let's assume A1 contains the formula =SUM(B1:B10) Select cell A1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =COUNT(B1:B10)=ROWS(B1:B10) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Arne" wrote in message ... I would like a cell to change color when a range of other cells all have a value entered. The cell I want to automatically format has the Sum function for a range of cells in it. When the range of cells that are being being used for the Sum function all have a value entered I would like the cell with the Sum to change either background color or font color. Is there an easy way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Conditional Formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating in Excel | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Conditional formating in excel | Excel Worksheet Functions |