Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
??conditional formatting??
In my spreadsheets there are several cells that depend upon each other and
when one of them is not filled out I have to go back thru the sheet and check for a blank cell. My question is can I use conditional formatting or a VB coding to color the cells background that are not filled in if another cell that depends on it is. Or use something like IfNull to color the background if the cell is unused. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
??conditional formatting??
You can, just add a CF formula such as
=A2="" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "tankerman" wrote in message ... In my spreadsheets there are several cells that depend upon each other and when one of them is not filled out I have to go back thru the sheet and check for a blank cell. My question is can I use conditional formatting or a VB coding to color the cells background that are not filled in if another cell that depends on it is. Or use something like IfNull to color the background if the cell is unused. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
??conditional formatting??
Bob that works for one of my sheets thanks for the help. One other question
how can I reverse it around and have a cell change color if anything is in another cell whether it is numbers or letters. I know a little about EXCEL but my boss think I can do anything he wants a spreadsheet to do. "Bob Phillips" wrote: You can, just add a CF formula such as =A2="" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "tankerman" wrote in message ... In my spreadsheets there are several cells that depend upon each other and when one of them is not filled out I have to go back thru the sheet and check for a blank cell. My question is can I use conditional formatting or a VB coding to color the cells background that are not filled in if another cell that depends on it is. Or use something like IfNull to color the background if the cell is unused. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
conditional formatting with formula | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |