Conditional Formatting Based on Specific Word in Different column in Same Row
How can I conditionally format (highlight) some cells in column K based on the values in column C of the same row?
I export a large report into excel from a worktool at work. I have many columns but I want to draw attention to cells in column K based on the text "###" on the same row in column C. (there are many different codes that populate besides ###)
The only thing I can think of is to highlight an individual cell in column K and go to 'Use a formula to determine which cells to format" My formula is: =$C$1="###" and format the highlighting color.
This report has over 500 rows so it is not feasible to do that same process 500 times and create 500 rules.
Last edited by CoryBrock; 08-16-2012 at 11:22 PM.
Re: Conditional Formatting Based on Specific Word in Different column in Same Row
Here is a screen shot. I have to manually highlight the cells green. I didnt highlight them all in this example. I would love for these cells to automatically highlight. I attached a screenshot. Unfortunately I cant attach the worksheet because it would be in violation of corporate policy. Any help would be much appreciated!!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1