ExcelBanter - Assigning Color in If Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Assigning Color in If Function (https://www.excelbanter.com/excel-worksheet-functions/175796-assigning-color-if-function.html)

Mary Fetsch

Assigning Color in If Function

In Excel 2003, can I assign color to a cell using the IF function? I want to
say "If amount 40, make it red, otherwise keep it black". Can I do that
with IF? If not, do you know another way? Thanks!

Teethless mama

Assigning Color in If Function

Conditional Formatting

Cell Value Is ; greater than; 40
format any color you like

"Mary Fetsch" wrote:

In Excel 2003, can I assign color to a cell using the IF function? I want to
say "If amount 40, make it red, otherwise keep it black". Can I do that
with IF? If not, do you know another way? Thanks!

Mary Fetsch

Assigning Color in If Function

Thanks for your quick response!

"Teethless mama" wrote:

Conditional Formatting

Cell Value Is ; greater than; 40
format any color you like

"Mary Fetsch" wrote:

In Excel 2003, can I assign color to a cell using the IF function? I want to
say "If amount 40, make it red, otherwise keep it black". Can I do that
with IF? If not, do you know another way? Thanks!

All times are GMT +1. The time now is 05:06 AM.