Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 29th 04, 12:27 AM
Wes T
 
Posts: n/a
Default 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   Report Post  
Old December 29th 04, 12:41 AM
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
Old December 29th 04, 01:11 AM
Wes T
 
Posts: n/a
Default

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
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
conditional format of data tables in charts [email protected] Charts and Charting in Excel 2 January 25th 05 03:56 PM
how do you format a row of cells based upon a value in another ce. hazenb1 Excel Discussion (Misc queries) 1 December 9th 04 04:22 AM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 7th 04 11:02 PM
make a conditional format the default Fred Evans Excel Discussion (Misc queries) 3 December 6th 04 05:01 AM
Conditional format rexmann Excel Discussion (Misc queries) 4 December 2nd 04 12:01 PM


All times are GMT +1. The time now is 12:36 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017