Hi

I have a spread sheet in which I want to highlight certain cells
automattically.
ie

B4 = 39
C4 = 38
how do I get Excel to highlight the figure in C4 if it is less than B4,
someone said it was something to do with exceptions but I cannot find any
details on that.
Hope someone can help

Dave

You can use conditional formatting...

1) Select C4

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=(C4<B4)

Note that if you don't want C4 highlighted when it's empty, use the
following formula instead...

=(C4<"")*(C4<B4)

4) Choose your formatting

5) Click Ok

Hope this helps!

In article ,
"Dave803" wrote:

Hi

I have a spread sheet in which I want to highlight certain cells
automattically.
ie

B4 = 39
C4 = 38
how do I get Excel to highlight the figure in C4 if it is less than B4,
someone said it was something to do with exceptions but I cannot find any
details on that.
Hope someone can help

Dave

Hi,
Have a look at "Conditional Formatting"....Format/Condtional
Formatting

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=488460

Domenic

Thanks for that I will try it and let you know.

Dave


"Domenic" wrote:

You can use conditional formatting...

1) Select C4

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=(C4<B4)

Note that if you don't want C4 highlighted when it's empty, use the
following formula instead...

=(C4<"")*(C4<B4)

4) Choose your formatting

5) Click Ok

Hope this helps!

In article ,
"Dave803" wrote:

Hi

I have a spread sheet in which I want to highlight certain cells
automattically.
ie

B4 = 39
C4 = 38
how do I get Excel to highlight the figure in C4 if it is less than B4,
someone said it was something to do with exceptions but I cannot find any
details on that.
Hope someone can help

Dave

Hi,

Use 'Conditional Formatting' which can be accessed from the 'Format' menu in
the Toolbar.

Select C4 -- "Format" -- "Conditional Formatting" -- clickon "Cell Value
Is" under 'Condition 1' and select "Formula Is" -- in the formula bar at its
side enter =$C$4<$B$4 -- clcik on the "Format" button at the bottom right
corner -- select the "Patterns" Tab and select a color -- "OK" -- "OK"

Regards,
B. R. Ramachandran
"Dave803" wrote:

Hi

I have a spread sheet in which I want to highlight certain cells
automattically.
ie

B4 = 39
C4 = 38
how do I get Excel to highlight the figure in C4 if it is less than B4,
someone said it was something to do with exceptions but I cannot find any
details on that.
Hope someone can help

Dave

Hi Dave,
Similar to your other answers but I would suggest
=AND($C4<"",$C4<$B4)
if you are only going to highlight one cell it will work, and if
you want to highlight the entire row for columns where the
column C value is less than the column B value it will work.

There are two things that you have to keep in mind when using
Conditional Formatting. The formula is relative to the active cell
when entering the formula, and the cells to be colored are among
those that are highlighted.

More information on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.hjtm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"B. R.Ramachandran" wrote ...
Select C4 -- "Format" -- "Conditional Formatting" -- clickon "Cell Value
Is" under 'Condition 1' and select "Formula Is" -- in the formula bar at its
side enter =$C$4<$B$4 -- click on the "Format" button at the bottom right
corner -- select the "Patterns" Tab and select a color -- "OK" -- "OK"

"Dave803" wrote:
B4 = 39
C4 = 38
how do I get Excel to highlight the figure in C4 if it is less than B4,

Hi everyone.
Thanks for your useful and very quick replies, I have now completed my
worksheet and it works fine with your "Conditional Formatting" suggestions.
Cheers guys

Dave