Copying Conditional Formatting to Adjacent Cells
I have a list of NBA Players in Column A with a list of Yes, No and Maybe in Column I. Based on what Column I lists, the color and fill changes to Green, Red and Yellow using conditional formatting. How do I copy the colors from Column I to Column A, with column A changing as Column I changes?
Re: Copying Conditional Formatting to Adjacent Cells
Are the current conditional formulas in column I formulas? or just checking Cell Values?
If they are formulas, change them so that there is a $ sign preceding each colum I reference.. e.g. =$I2>0 Then you can copy formats to any column.
if the conditions are Cell Value Is type conditions, then in Column A use formulas and enter something like =$I2>0 (or whatever the condition needs to be) and repeat for the other colours...
(Where I2 is top most cell you are applying conditional format to)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1