| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format a cell based on color of another
Hi,
I would like to conditional format cell a2 to red only if a1 is red. Does anyone knows how to do that? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format a cell based on color of another
You'll need to write a formula in a2 that points to a1 and returns a value
you can use for conditional formatting; e.g., if your conditional format for a1 is set to make it red if its value is greater than 0, you could write the following formula in a2 with the same conditional format: =IF(A10,1,0) "Marlo" wrote: Hi, I would like to conditional format cell a2 to red only if a1 is red. Does anyone knows how to do that? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format a cell based on color of another
You don't need the IF(...,1,0)
Your formula could be merely =A10 -- David Biddulph "Daryl Fagala" wrote in message ... You'll need to write a formula in a2 that points to a1 and returns a value you can use for conditional formatting; e.g., if your conditional format for a1 is set to make it red if its value is greater than 0, you could write the following formula in a2 with the same conditional format: =IF(A10,1,0) "Marlo" wrote: Hi, I would like to conditional format cell a2 to red only if a1 is red. Does anyone knows how to do that? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format a cell based on color of another
then you can also change the format of the cell font color and use the
conditional formating when you want it to show up or not. "Daryl Fagala" wrote: You'll need to write a formula in a2 that points to a1 and returns a value you can use for conditional formatting; e.g., if your conditional format for a1 is set to make it red if its value is greater than 0, you could write the following formula in a2 with the same conditional format: =IF(A10,1,0) "Marlo" wrote: Hi, I would like to conditional format cell a2 to red only if a1 is red. Does anyone knows how to do that? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
| Conditional Format a row based on a cell? | Excel Worksheet Functions | |||
| Conditional Format based on other cell | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
Hybrid Mode
