help with using Conditional Formatting
 

Hi,
I'm trying to set up conditional formating in my spreadsheet such that if
the value in column E is 100% that row should be colored with gray. No
matter what I try I can't seem to get this to work. Any help will be
appreciated.
Thanks
Amit

Try this experiment:

Select say, rows 2 to 5
(select the row headers on the left)

Click Format Conditional Formatting
Under Condition 1:
Formula Is | =$E2=1
Click Format button Patterns tab Gray OK
Click OK at the main dialog

Test by inputting into col E
(except E1, which is not covered)

Input in E3: 100%
(or the number "1")
the entire row3 should be filled with gray color

Clear E3, the color disappears ...
And so on

Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Amit" wrote in message
...
Hi,
I'm trying to set up conditional formating in my spreadsheet such that if
the value in column E is 100% that row should be colored with gray. No
matter what I try I can't seem to get this to work. Any help will be
appreciated.
Thanks
Amit

That did it. The key was to use $E2. Thanks very much!
-amit


"Max" wrote in message
...
Try this experiment:

Select say, rows 2 to 5
(select the row headers on the left)

Click Format Conditional Formatting
Under Condition 1:
Formula Is | =$E2=1
Click Format button Patterns tab Gray OK
Click OK at the main dialog

Test by inputting into col E
(except E1, which is not covered)

Input in E3: 100%
(or the number "1")
the entire row3 should be filled with gray color

Clear E3, the color disappears ...
And so on

Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Amit" wrote in message
...
Hi,
I'm trying to set up conditional formating in my spreadsheet such that
if
the value in column E is 100% that row should be colored with gray. No
matter what I try I can't seem to get this to work. Any help will be
appreciated.
Thanks
Amit

Glad to hear that !
Thanks for feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Amit" wrote in message
...
That did it. The key was to use $E2. Thanks very much!
-amit

Amit

Select rows(not cells) to Format.

Then FormatCellsFormula is =$E1=1

Pick a gray color from the Format dialog and OK your way out.

NOTE: the dollar sign($) in $E1 must be entered.


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 16:25:37 -0500, "Amit" wrote:

Hi,
I'm trying to set up conditional formating in my spreadsheet such that if
the value in column E is 100% that row should be colored with gray. No
matter what I try I can't seem to get this to work. Any help will be
appreciated.
Thanks
Amit