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 Using conditional formatting in Excel 2007

This is probably a stupid question, but I am creating a database, in which I
want the cells in ex. range A2:G57 to highlight a certain color, but only if
the cell in the same row has a value of 1. Please understand that I don't
want all of the cells (A2:G57) to change, just the cells on the same row as
the cell that =1.

Any help is greatly appreciated. Please reply as if you're speaking to an
idiot who has never used Excel... Cause you are...

Thanks.
 
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 Formatting in Excel 2007 SDR Excel Discussion (Misc queries) 0 November 23rd 07 06:57 AM
Conditional Formatting in Excel 2007 JOHN HARRIS Excel Worksheet Functions 1 November 14th 07 07:11 PM
Conditional formatting in Excel 2007 Mike Tordoff Excel Discussion (Misc queries) 3 May 19th 07 07:20 AM
Conditional Formatting: Excel 2003 vs. 2007 JP Excel Worksheet Functions 3 January 13th 07 11:33 PM
Conditional Formatting in Excel 2007 Jessica Excel Discussion (Misc queries) 0 August 23rd 06 03:34 PM


All times are GMT +1. The time now is 10:26 PM.

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"