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: 11
Default how can I conditionally format a cell based on the value in a diff

How can I conditionally format a cell based on the value in a different cell.

I have two columns of information. None of the information in the cells I am
trying to format is numeric. I am trying to track names to loans that are
with the company. If they wrote outside, I need to keep track of which other
company it was written with.

The First column currently has a conditional format to highlight the cell if
the value is = "Home". The other values that are entered are variations of
"Outside". I have to keep the variations as they are, in order to track which
loans went with which other company.

The second column has the borrowers name. I need this column to highlight
the cells if the loan was written outside.

So if the cell is highlighted in column A, it should not be highlighted in
the column B.
And Vice versa.

 
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
How do I conditionally delete rows based on cell contents? John Chan Excel Worksheet Functions 3 May 17th 23 03:45 AM
How do I conditionally format only some of the text in a cell? Goo Excel Worksheet Functions 9 April 9th 10 07:55 PM
Conditionally format points based on a third column hmm Charts and Charting in Excel 3 October 14th 07 09:35 AM
Create formula that will pull a value based on text in diff cell? So Tru Geo Excel Discussion (Misc queries) 0 June 22nd 06 08:16 PM
Conditionally format one cell for contents of another? Basher Bates Excel Worksheet Functions 2 May 6th 06 07:39 PM


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