| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell formatting
I want to change the background color of a cell based upon the results of
different cell in the same row. For example, if c5 = "" then c4 background color = yellow. Can someone help? Frank Natalie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell formatting
Frank
Try setting the Conditional Format of cell c4. Make Condtion 1, Formula is =C5="" and set the format as you want it. Good luck. Ken Norfolk, Va On Oct 5, 12:36 pm, Frank Natalie <Frank wrote: I want to change the background color of a cell based upon the results of different cell in the same row. For example, if c5 = "" then c4 background color = yellow. Can someone help? Frank Natalie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell formatting
Thanks Ken for the help, it worked perfectly....
Frank Natalie " wrote: Frank Try setting the Conditional Format of cell c4. Make Condtion 1, Formula is =C5="" and set the format as you want it. Good luck. Ken Norfolk, Va On Oct 5, 12:36 pm, Frank Natalie <Frank wrote: I want to change the background color of a cell based upon the results of different cell in the same row. For example, if c5 = "" then c4 background color = yellow. Can someone help? Frank Natalie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
| Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
Linear Mode
