conditianal formulas
Hi All
I am trying to use conditional formatting to change colors of cells for scheduling purposes. There are a large amount (20) of criteria that could make a cell one of three colors (representing work shifts). Each criteria represents a work center and hours of work, ie 1-8, workstation 1 for 8 hours. The cell will look like this,1-8 (1), work center 1, 8 hours, on shift 1. I need Excel to recognize the 1 and assign a corresponding color. If anyone could offer any assistance on the formula or formula setup, I would greatly appreciate it. |
Hi!
The cell will look like this,1-8 (1) I need Excel to recognize the 1 Which one? =ISNUMBER(SEARCH("1-",A1)) =ISNUMBER(SEARCH("(1)",A1)) Biff "Matt" wrote in message ... Hi All I am trying to use conditional formatting to change colors of cells for scheduling purposes. There are a large amount (20) of criteria that could make a cell one of three colors (representing work shifts). Each criteria represents a work center and hours of work, ie 1-8, workstation 1 for 8 hours. The cell will look like this,1-8 (1), work center 1, 8 hours, on shift 1. I need Excel to recognize the 1 and assign a corresponding color. If anyone could offer any assistance on the formula or formula setup, I would greatly appreciate it. |
All times are GMT +1. The time now is 11:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com