Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set "value if true" to "fill cell with color"
I want to use an IF statement to check for text in a cell range and if true,
then fill a cell with a highlight color. In my application, I would look for "PD" in invoice date fields and if found, highlight the amount invoiced in green. I don't know the snytax to write the return value as "fill this cell with color". |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
set "value if true" to "fill cell with color"
You can't do what you want in the way that you describe, that is, with a
formula. Have a look at conditional formatting. That will do what you want. Assume that your invoice dates are in column C, starting in row 2. In Cell D2, or whatever: Format | Conditional Formatting... | Condition 1: Formula is | =C2="pd" Change the format as required, for example, Format | Patterns = green Copy the formatting to the other cells you want to highlight. Regards Trevor "Feeta" wrote in message ... I want to use an IF statement to check for text in a cell range and if true, then fill a cell with a highlight color. In my application, I would look for "PD" in invoice date fields and if found, highlight the amount invoiced in green. I don't know the snytax to write the return value as "fill this cell with color". |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
set "value if true" to "fill cell with color"
Check out Conditional Formatting...
No code required. Just use a formula condition. -- steveB Remove "AYN" from email to respond "Feeta" wrote in message ... I want to use an IF statement to check for text in a cell range and if true, then fill a cell with a highlight color. In my application, I would look for "PD" in invoice date fields and if found, highlight the amount invoiced in green. I don't know the snytax to write the return value as "fill this cell with color". |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
set "value if true" to "fill cell with color"
Thank you, this is exactly what I needed to know. I appreciate the detail you
provided. "Trevor Shuttleworth" wrote: You can't do what you want in the way that you describe, that is, with a formula. Have a look at conditional formatting. That will do what you want. Assume that your invoice dates are in column C, starting in row 2. In Cell D2, or whatever: Format | Conditional Formatting... | Condition 1: Formula is | =C2="pd" Change the format as required, for example, Format | Patterns = green Copy the formatting to the other cells you want to highlight. Regards Trevor "Feeta" wrote in message ... I want to use an IF statement to check for text in a cell range and if true, then fill a cell with a highlight color. In my application, I would look for "PD" in invoice date fields and if found, highlight the amount invoiced in green. I don't know the snytax to write the return value as "fill this cell with color". |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
set "value if true" to "fill cell with color"
You're welcome, thanks for the feedback.
"Feeta" wrote in message ... Thank you, this is exactly what I needed to know. I appreciate the detail you provided. "Trevor Shuttleworth" wrote: You can't do what you want in the way that you describe, that is, with a formula. Have a look at conditional formatting. That will do what you want. Assume that your invoice dates are in column C, starting in row 2. In Cell D2, or whatever: Format | Conditional Formatting... | Condition 1: Formula is | =C2="pd" Change the format as required, for example, Format | Patterns = green Copy the formatting to the other cells you want to highlight. Regards Trevor "Feeta" wrote in message ... I want to use an IF statement to check for text in a cell range and if true, then fill a cell with a highlight color. In my application, I would look for "PD" in invoice date fields and if found, highlight the amount invoiced in green. I don't know the snytax to write the return value as "fill this cell with color". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |