LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default How Do I Condition A Entire Row, Based On The Content Of A Single

Hi All

How Do I Condition A Entire Row, Based On The Content Of A Single Cell


I have a simple spreadsheet. 40 Rows long and 8 Columns wide. Column 8
(the last Column) contains a single word. Depending on what that word is, I
want the entire row to turn into another colour.

So far. I've only managed to work out how to condition the invidual cell.
Any ideas?


Kind Regards
Emmily.

 
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
Condition font color in a single cell based on its formula data. Bee Excel Worksheet Functions 3 February 19th 08 12:09 AM
how do I highlight an entire row based on the value of its content strider Excel Discussion (Misc queries) 1 December 16th 05 09:17 PM
Hide/Delete entire rows based in the content of one cell Clueless Excel Discussion (Misc queries) 2 October 3rd 05 02:40 PM
Can I format an entire row based on the value of a single cell? LTShelley Excel Discussion (Misc queries) 1 August 11th 05 07:37 PM
In Excel, can I shade entire rows based on the value of a single . Todd Excel Worksheet Functions 1 March 24th 05 05:52 PM


All times are GMT +1. The time now is 09:24 AM.

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

About Us

"It's about Microsoft Excel"