| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula if a conditional format exists
If A1=1, and B1 has a conditional format that changes the color to red if A1
equals 1, what is the IF formula to change C1 to a zero if B1 is red. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula if a conditional format exists
=IF(A1=0,1)
The same condition applies -- Gary''s Student "Shu of AZ" wrote: If A1=1, and B1 has a conditional format that changes the color to red if A1 equals 1, what is the IF formula to change C1 to a zero if B1 is red. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format if the cell contains a formula | Excel Worksheet Functions | |||
| Conditional format if a cell has a formula or if a percent or numb | Excel Discussion (Misc queries) | |||
| Conditional format formula | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Conditional Format Formula Needed | Excel Worksheet Functions | |||
Linear Mode
