Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set a Conditional Format for ROWs based on the value of .
I want to format a row based on the value of another cell. eg If cell N10
25 then fill (hi-light) row 10 (or A10:N10) with red colour. |
#2
|
|||
|
|||
Select A10:N10 or the entire row 10 if desired.
FormatConditional FormattingFormula is: =$N1025 Note the $ sign must be entered to make Column N absolute. Pick a suitable red color from the FormatPatterns chart and OK your way out. Gord Dibben Excel MVP On Tue, 28 Dec 2004 16:27:02 -0800, "Wes T" <Wes wrote: I want to format a row based on the value of another cell. eg If cell N10 25 then fill (hi-light) row 10 (or A10:N10) with red colour. |
#3
|
|||
|
|||
Thankyou Gord
The $ sign !!!!!! Spent hours searching help etc. Knew it had to be something simple. Thanks again. Craig West "Gord Dibben" wrote: Select A10:N10 or the entire row 10 if desired. FormatConditional FormattingFormula is: =$N1025 Note the $ sign must be entered to make Column N absolute. Pick a suitable red color from the FormatPatterns chart and OK your way out. Gord Dibben Excel MVP On Tue, 28 Dec 2004 16:27:02 -0800, "Wes T" <Wes wrote: I want to format a row based on the value of another cell. eg If cell N10 25 then fill (hi-light) row 10 (or A10:N10) with red colour. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
how do you format a row of cells based upon a value in another ce. | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) | |||
Conditional format | Excel Discussion (Misc queries) |