Conditional Formatting Q
How could I set a Conditional Format for a cell (to turn white text)
if the cells contents includes at least the following text location # I have a number of possible wording within the cell and any contain the above text I wish to change to white font. Not sure how to do this with 'variable' text Thanks |
Conditional Formatting Q
I think you missed something from your post - can you give a few
examples of what you mean by "variable" text? Pete On Nov 27, 12:57 pm, Sean wrote: How could I set a Conditional Format for a cell (to turn white text) if the cells contents includes at least the following text location # I have a number of possible wording within the cell and any contain the above text I wish to change to white font. Not sure how to do this with 'variable' text Thanks |
Conditional Formatting Q
Hey, just did this based on an archived post
=FIND("Location #",A10) 0, this is posted within CF in cell A10 |
All times are GMT +1. The time now is 12:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com