LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jc jc is offline
external usenet poster
 
Posts: 164
Default Conditional format entire column

Hey guys,
I have two colums "A" & "B" with dollar values all the way down in each (500
rows)...I want to conditional format them quick...so IE:

If A1B1 then color cell A1 red...

how do i get that to copy all the way down my column so A2 & B2 look at each
other and A3 & B3 look at each other and so on?

thanks!!
~JC
 
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
Expanding Conditional Format Rule to entire Column KKD Excel Discussion (Misc queries) 1 May 27th 09 07:58 PM
Conditional Format entire row CrimsonPlague29 Excel Discussion (Misc queries) 3 March 1st 08 02:04 AM
color entire row by using conditional format capital letter Excel Worksheet Functions 1 November 10th 07 09:24 AM
Conditional format based on entire row LisaVH Excel Worksheet Functions 8 January 17th 07 07:29 PM
Conditional Format to Highlight entire Row? shital shah Excel Worksheet Functions 1 August 25th 05 04:37 PM


All times are GMT +1. The time now is 10:37 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"