Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |