LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 88
Default conditional format columns

I am trying to set a conditional format to 3 different columns. The issue
I'm having is, I need to have a formula that says something like if G2 = X2
then fill it yellow. G3 = X3 fill yellow, G4 = X4 fill yellow and so on. I
normally wouldn't mind setting it up manually for each cell but there is 2066
rows and 3 different columns to conditionally format.

Thanks for any tips in advance.
 
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
Capture conditional format as cell format Diddy Excel Discussion (Misc queries) 2 June 23rd 09 11:01 PM
Copying conditional format across columns Porky79 Excel Discussion (Misc queries) 1 April 24th 09 08:28 PM
How to conditional format columns in a range based on BlyChris Excel Worksheet Functions 5 July 25th 08 06:10 AM
New Conditional Format Overriding Previous Conditional Format Rene Excel Discussion (Misc queries) 3 February 27th 08 06:08 PM
Conditional Format ... Compare Columns? Ken Excel Discussion (Misc queries) 5 March 25th 05 09:19 AM


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