Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Conditional Formating an entire row

How do I apply conditional formatting to an entire row based on one cell?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Conditional Formating an entire row

CF/ Formula Is/ =$A1=42

Note: Formula Is, not Cell Value Is, and note absolute addressing for
column reference.
--
David Biddulph

"cardosol" wrote in message
...
How do I apply conditional formatting to an entire row based on one cell?




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 formating - dragging a cond. format over an entire col KIpp Excel Worksheet Functions 4 February 7th 09 06:34 PM
How can Iextend a cell conditional formating to an entire line ? Luc Bongoy Excel Worksheet Functions 2 July 26th 07 03:02 PM
Conditional Formating based on data in an entire row ked Setting up and Configuration of Excel 1 January 9th 07 06:35 PM
Help using Conditional Formating of Entire Rows [email protected] Excel Worksheet Functions 4 February 16th 05 04:29 PM
How to change an entire row using conditional formating John Edwards Excel Discussion (Misc queries) 2 December 9th 04 05:41 PM


All times are GMT +1. The time now is 02:05 AM.

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

About Us

"It's about Microsoft Excel"