Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 7th 08, 04:22 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3
Default 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?

  #2   Report Post  
Old November 7th 08, 04:28 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 3
Default 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?

  #3   Report Post  
Old November 7th 08, 04:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3
Default 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?

  #5   Report Post  
Old November 7th 08, 04:59 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 1,358
Default 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?



  #6   Report Post  
Old November 7th 08, 05:28 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default 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?

  #7   Report Post  
Old November 7th 08, 06:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3
Default 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?

  #8   Report Post  
Old November 9th 08, 07:09 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill color and font color icons do not work in excel huer59 Excel Discussion (Misc queries) 0 November 29th 07 01:06 PM
trouble with viewing fill color and font color CMinard Excel Worksheet Functions 3 May 12th 06 09:09 PM
Fill color doesn't work although font color does. Marco Excel Worksheet Functions 1 May 8th 06 12:44 AM
Sort or sub-total by Fill color or font color Excel_seek_help Excel Discussion (Misc queries) 1 April 27th 06 09:01 PM
My fill color and font color do not work in Excel Std Edition 2003 chapstick Excel Discussion (Misc queries) 1 September 11th 05 08:48 PM


All times are GMT +1. The time now is 01:08 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017