| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change fill color based on value of another cell in Excel
How would I set/change the fill color of one cell of an Excel spreadsheet
based on the value of another cell on the same Excel spreadsheet? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change fill color based on value of another cell in Excel
Select the cell (say B1) and pull-down:
Format Conditional Formatting... and pick formula is =(A1="") and select you format (say fill red) Then if A1 is empty, then B1 will show as red, otherwise not red. -- Gary''s Student "ForensicAccountant" wrote: How would I set/change the fill color of one cell of an Excel spreadsheet based on the value of another cell on the same Excel spreadsheet? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change fill color based on value of another cell in Excel
Using conditional formatting under the formatting menu. In the dialog,
change cell value is to Formula is and put in a formula that reacts to the value in the other cell, producing True or False. -- Regards, Tom Ogilvy "ForensicAccountant" wrote in message ... How would I set/change the fill color of one cell of an Excel spreadsheet based on the value of another cell on the same Excel spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel change color of a range of cells based on a cell value | Excel Worksheet Functions | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| need a way to set value based on fill color of a cell | Excel Programming | |||
| How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Hybrid Mode
