I don't know if it matters but I am working on an .xls document in compatibility mode using MS excel 2010.
Using this forum I was able to write conditional formatting formulas that would automatically change the color of entire rows anywhere on the spreadsheet whenever 1 of 6 different names were entered in one column and the next column contained either "PU" or "DO". This was a great feat for me as I am by no means an expert and do not know VBA. However cool this was, I would still need to rewrite the conditional formatting for the entire sheet when new names occur in the future.
I would like to select which format type used in conditional formatting remotely - e.g. by formatting a cell (say T1) in Green I could then have the conditional format refer to that cell to select green text formatting to use on the proscribed condition.
-__T__U
1__1__Matthew
2__2__Landon
A related, and likely simpler request is to also have conditions referenced remotely - e.g. a list of names that would trigger the conditional formatting.
Ideally the name could be formatted as desired to show in conditional formatting, then I could skip colored numbers & just have list of names.
In this way, as the possible names change over time I would not need to rewrite the formulas to conditionally format the worksheet, I could write the formulas once and then just enter names in a list using formatting I desire and the conditional format formulas would do the rest!
Bookmarks