| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I need to change the fill color based on the values of other cells.
Ex. if A1 is not a null value and the cell I want to format A2 is a null then I need A2 to have a red fill color and a certain text. If A2 isn't a null then it should turn green. If A1 and A2 have null values then A2 should be yellow. So just to sum up A1<"" and A2 ="" then Make A2=Red Fill Color + text A1<"" and A2 <"" then A2=Green Fill Color A1="" and A2 ="" then A2=Yellow Fill Color Thanks for the help all. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
What version of Excel are you using?
-- Biff Microsoft Excel MVP "Anthony" wrote in message ... I need to change the fill color based on the values of other cells. Ex. if A1 is not a null value and the cell I want to format A2 is a null then I need A2 to have a red fill color and a certain text. If A2 isn't a null then it should turn green. If A1 and A2 have null values then A2 should be yellow. So just to sum up A1<"" and A2 ="" then Make A2=Red Fill Color + text A1<"" and A2 <"" then A2=Green Fill Color A1="" and A2 ="" then A2=Yellow Fill Color Thanks for the help all. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
Select Cell A2
Format | Conditional Format... Condition1 Formula is =and(A1<"", A2="") Format to a red colour Condition 2 =and(A1="", A2="") Format to a yellow colour Condition 3 =and(A1<"", A2<"") Format to a green colour As for adding Text that is not possible with a CF. You will want to put a formula in an adjacent cell to pop up the text. There is a way to do it with the camera tool but it is kind of fussy to set up. http://spreadsheetpage.com/index.php...e_camera_tool/ -- HTH... Jim Thomlinson "Anthony" wrote: I need to change the fill color based on the values of other cells. Ex. if A1 is not a null value and the cell I want to format A2 is a null then I need A2 to have a red fill color and a certain text. If A2 isn't a null then it should turn green. If A1 and A2 have null values then A2 should be yellow. So just to sum up A1<"" and A2 ="" then Make A2=Red Fill Color + text A1<"" and A2 <"" then A2=Green Fill Color A1="" and A2 ="" then A2=Yellow Fill Color Thanks for the help all. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
Tank you works well.
"Jim Thomlinson" wrote: Select Cell A2 Format | Conditional Format... Condition1 Formula is =and(A1<"", A2="") Format to a red colour Condition 2 =and(A1="", A2="") Format to a yellow colour Condition 3 =and(A1<"", A2<"") Format to a green colour As for adding Text that is not possible with a CF. You will want to put a formula in an adjacent cell to pop up the text. There is a way to do it with the camera tool but it is kind of fussy to set up. http://spreadsheetpage.com/index.php...e_camera_tool/ -- HTH... Jim Thomlinson "Anthony" wrote: I need to change the fill color based on the values of other cells. Ex. if A1 is not a null value and the cell I want to format A2 is a null then I need A2 to have a red fill color and a certain text. If A2 isn't a null then it should turn green. If A1 and A2 have null values then A2 should be yellow. So just to sum up A1<"" and A2 ="" then Make A2=Red Fill Color + text A1<"" and A2 <"" then A2=Green Fill Color A1="" and A2 ="" then A2=Yellow Fill Color Thanks for the help all. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
