| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell change color based on the value of another?
I would like to have the fill color of one cell change based on the
comparison of values in two other cells. For example, if the number in C4 is larger than the number in C3 can C5 turn red? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a cell change color based on the value of another?
Use conditional formatting in C5 with Condition 1 of Formula Is and a
formula of =C4C3 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Woodenkettle" wrote in message ... I would like to have the fill color of one cell change based on the comparison of values in two other cells. For example, if the number in C4 is larger than the number in C3 can C5 turn red? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a cell change color based on the value of another?
Conditional formatting on C5. Format-Conditional Formatting.
Select FormulaIs. =C$4$C$3 Thsn set your format colors from the format button. Changing the cell background is Pattern. HTH, Paul "Woodenkettle" wrote in message ... I would like to have the fill color of one cell change based on the comparison of values in two other cells. For example, if the number in C4 is larger than the number in C3 can C5 turn red? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| Change tab color based on a cell value | Excel Discussion (Misc queries) | |||
| Change Cell Color Based on IF Statement | Excel Worksheet Functions | |||
| cell color change based on due date | New Users to Excel | |||
Hybrid Mode
