ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   add fill color or font color to if function (https://www.excelbanter.com/excel-worksheet-functions/209481-add-fill-color-font-color-if-function.html)

MEDaniel

add fill color or font color to if function
 
I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?

Nattasiray

add fill color or font color to if function
 
You should using Conditional Formatting

Suppose cell that you check is I17
Select Cell I17
click format - Conditional formatting
set condition to Formula is
enter =and(E17<G16, E17<H16)=true at the text box
click format the set font color and cell fill
click ok button at each dialog

"MEDaniel" wrote:

I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?


MEDaniel

add fill color or font color to if function
 
Added conditional formatting. Typed number into cell. no color change. ????

"Nattasiray" wrote:

You should using Conditional Formatting

Suppose cell that you check is I17
Select Cell I17
click format - Conditional formatting
set condition to Formula is
enter =and(E17<G16, E17<H16)=true at the text box
click format the set font color and cell fill
click ok button at each dialog

"MEDaniel" wrote:

I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?


Nattasiray

add fill color or font color to if function
 
Please send file to me at . I will figure out.

"MEDaniel" wrote:

Added conditional formatting. Typed number into cell. no color change. ????

"Nattasiray" wrote:

You should using Conditional Formatting

Suppose cell that you check is I17
Select Cell I17
click format - Conditional formatting
set condition to Formula is
enter =and(E17<G16, E17<H16)=true at the text box
click format the set font color and cell fill
click ok button at each dialog

"MEDaniel" wrote:

I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?


John C[_2_]

add fill color or font color to if function
 
The =TRUE is unnecessary. As long as all cells E17, G16, H16 have numbers
(and not text that looks like numbers), then this should work:
=AND(E17<G16,E17<H16)
--
** John C **

"MEDaniel" wrote:

Added conditional formatting. Typed number into cell. no color change. ????

"Nattasiray" wrote:

You should using Conditional Formatting

Suppose cell that you check is I17
Select Cell I17
click format - Conditional formatting
set condition to Formula is
enter =and(E17<G16, E17<H16)=true at the text box
click format the set font color and cell fill
click ok button at each dialog

"MEDaniel" wrote:

I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?


ShaneDevenshire

add fill color or font color to if function
 
Hi,

you can use a rather shorter formula as described below:

2003:
1. Select your range
2. Choose Format, Conditional Formatting
3. From the first dropdown pick Formula is
4. In the next box enter your formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Patterns tab, pick a color
6. Click OK twice.


2007:
1. Select your range
2. Choose Home, Conditional Formatting, New Rule
3. Pick Use a formula to determine which cells to format
4. In the Format values where this formula is true, enter the formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Fill tab choose a color
6. Click OK twice.

--
Thanks,
Shane Devenshire


"MEDaniel" wrote:

I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?


MEDaniel

add fill color or font color to if function
 
Thanks ShaneDevenshire. That did the trick!

"ShaneDevenshire" wrote:

Hi,

you can use a rather shorter formula as described below:

2003:
1. Select your range
2. Choose Format, Conditional Formatting
3. From the first dropdown pick Formula is
4. In the next box enter your formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Patterns tab, pick a color
6. Click OK twice.


2007:
1. Select your range
2. Choose Home, Conditional Formatting, New Rule
3. Pick Use a formula to determine which cells to format
4. In the Format values where this formula is true, enter the formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Fill tab choose a color
6. Click OK twice.

--
Thanks,
Shane Devenshire


"MEDaniel" wrote:

I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?


ShaneDevenshire

add fill color or font color to if function
 
Thanks for the feedback!
--
Thanks,
Shane Devenshire


"MEDaniel" wrote:

Thanks ShaneDevenshire. That did the trick!

"ShaneDevenshire" wrote:

Hi,

you can use a rather shorter formula as described below:

2003:
1. Select your range
2. Choose Format, Conditional Formatting
3. From the first dropdown pick Formula is
4. In the next box enter your formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Patterns tab, pick a color
6. Click OK twice.


2007:
1. Select your range
2. Choose Home, Conditional Formatting, New Rule
3. Pick Use a formula to determine which cells to format
4. In the Format values where this formula is true, enter the formula:
=AND(E17<G16:H16)
5. Click the Format button and on the Fill tab choose a color
6. Click OK twice.

--
Thanks,
Shane Devenshire


"MEDaniel" wrote:

I am trying to write a formula so that if E17<G16andE17<H16, red cell fill or
red font. Any idea how to do this?



All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com