Is there any way to automatically color code cells, based on formula outcome?

[crisancomis]

I have a formula to show me the days of a month, I was wondering if the same formula could be somewhat tweaked to make the days that turn out to be Saturdays and Sundays be a specific color then the blank Monday to Friday ones?

Is such a thing even possible? Or can you only do it manually?

[NeedForExcel]

You need Conditional Formatting

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

[sktneer]

As per your description, you may achieve this with the help of the Conditional Formatting.

Let's assume you have dates in column A starting from Row2 and in column B you have a formula to show the day's name for the corresponding dates in col. A, then select the whole column B and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.

Please Login or Register  to view this content.

In the attached, I have used red, bold and italic font.
For more details, please refer to the attached.

[crisancomis]

You need Conditional Formatting

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

i did as you asked

[crisancomis]

i actually wanted the cell containing the text colored, not the text itself

[crisancomis]

As per your description, you may achieve this with the help of the Conditional Formatting.

Let's assume you have dates in column A starting from Row2 and in column B you have a formula to show the day's name for the corresponding dates in col. A, then select the whole column B and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.

Please Login or Register  to view this content.

In the attached, I have used red, bold and italic font.
For more details, please refer to the attached.

i actually wanted the cell containing the text colored, not the text itself

[crisancomis]

As per your description, you may achieve this with the help of the Conditional Formatting.

Let's assume you have dates in column A starting from Row2 and in column B you have a formula to show the day's name for the corresponding dates in col. A, then select the whole column B and make a New Rule for conditional formatting using the formula given below and set the format as per your choice.

Please Login or Register  to view this content.

In the attached, I have used red, bold and italic font.
For more details, please refer to the attached.

i actually wanted the cell containing the text colored, not the text itself