| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Background color change, by using the formula.
I want to change the background color of the cell by using conditional formula.
like... Cell A1's Background color should be Red, if B1C1 Black, if B1=C1 & Green, if B1<C1. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Background color change, by using the formula.
Select A1
Go to Format -- Conditional Formatting... Choose Formula is and enter: =B1C1 format your background by clicking on format... then add a rule and change to Formula is and enter: =B1=C1 and format the background. and then last but not least add the last rule, change to formula is and enter: =B1<C1 hth Carlo On Dec 21, 3:03*pm, Sarveshwar Trangadia <Sarveshwar wrote: I want to change the background color of the cell by using conditional formula. like... Cell A1's Background color should be * * * * * *Red, if B1C1 * * * * * *Black, if B1=C1 & * * * * * *Green, if B1<C1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
| Auto change background of color based on formula | Excel Worksheet Functions | |||
| how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
| Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
| Dynamically change cell range in formula by background color? | Excel Programming | |||
Hybrid Mode
