| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting on Color
Is there a way to conditionally format a cell to a color only if a referenced
cell is already conditionally formatted to a color. Ex; format cell A2 to red if cell A1 is conditionally formatted to yellow? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on Color
You can check for the same logic applied to the other conditionally formatted
cell. Using your example, if A1 is conditionally formatted to yellow when the cell value is 1, then, you can conditionally format A2 to red with the formula "=A11" "Excel Learner" wrote: Is there a way to conditionally format a cell to a color only if a referenced cell is already conditionally formatted to a color. Ex; format cell A2 to red if cell A1 is conditionally formatted to yellow? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on Color
I think that is in the right directions. Can I format the cell for multiple
conditions. Ex: Format A1 to yellow if B1 is 1, then format A2 to red if B2 is 1 and B1 1? "Vergel Adriano" wrote: You can check for the same logic applied to the other conditionally formatted cell. Using your example, if A1 is conditionally formatted to yellow when the cell value is 1, then, you can conditionally format A2 to red with the formula "=A11" "Excel Learner" wrote: Is there a way to conditionally format a cell to a color only if a referenced cell is already conditionally formatted to a color. Ex; format cell A2 to red if cell A1 is conditionally formatted to yellow? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on Color
Yes, by using a formula like this for the A2 conditional format:
=AND(B11, B21) "Excel Learner" wrote: I think that is in the right directions. Can I format the cell for multiple conditions. Ex: Format A1 to yellow if B1 is 1, then format A2 to red if B2 is 1 and B1 1? "Vergel Adriano" wrote: You can check for the same logic applied to the other conditionally formatted cell. Using your example, if A1 is conditionally formatted to yellow when the cell value is 1, then, you can conditionally format A2 to red with the formula "=A11" "Excel Learner" wrote: Is there a way to conditionally format a cell to a color only if a referenced cell is already conditionally formatted to a color. Ex; format cell A2 to red if cell A1 is conditionally formatted to yellow? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting on Color
Thank you for the help, I knew there was an easier way than trying to look at
the color properties of the cell. "Vergel Adriano" wrote: Yes, by using a formula like this for the A2 conditional format: =AND(B11, B21) "Excel Learner" wrote: I think that is in the right directions. Can I format the cell for multiple conditions. Ex: Format A1 to yellow if B1 is 1, then format A2 to red if B2 is 1 and B1 1? "Vergel Adriano" wrote: You can check for the same logic applied to the other conditionally formatted cell. Using your example, if A1 is conditionally formatted to yellow when the cell value is 1, then, you can conditionally format A2 to red with the formula "=A11" "Excel Learner" wrote: Is there a way to conditionally format a cell to a color only if a referenced cell is already conditionally formatted to a color. Ex; format cell A2 to red if cell A1 is conditionally formatted to yellow? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color Conditional Formatting | Excel Worksheet Functions | |||
| check text color from conditional formatting w/out using VB | Excel Discussion (Misc queries) | |||
| Conditional Formatting and Cell Color | Excel Worksheet Functions | |||
| Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
| Cell color change without using conditional formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
