cell format help

D

darkbearpooh1

I need to conditional format a cell based on the condition of a
different cell is this possible? could someone post a formula to help
me?
 
E

Elkar

Let's say you want to Conditionally Format cell A1 to become red if cell B1 =
5.

1. Select Cell A1
2. Choose "Conditional Formatting" from the Format Menu
3. Under Condition 1, change "Cell Value Is" to "Formula Is"
4. Enter the formula: =B1=5
5. Change the Background Color to Red (or whatever you want)
6. Click OK

HTH,
Elkar
 
D

darkbearpooh1

Ok, Now how do i make it accept a range like you said conditional format
if A1=5 but I need it to accept several different numbers and still
change color?
 
E

Elkar

You could use the AND and OR functions.

=OR(B1=5,B1=10,B1=15)

=OR(AND(B1>=5,B1<=10),B1=15)
 
D

darkbearpooh1

Thank you so much for the help but i am still struggling,
started to work then something keeps going wrong.
Maybe if i explain what i am trying to do someone can offer a better
solution?

I am making a Crew schedule worksheet at the top in the rows going
across is the number of employees needed for that hour and each hour is
seperated by cell.
going down i just have listed crew 1, crew 2 ect. but the names will be
filled in later so i can just put 1,2,3 ect or whatever helps if a
numeric value is better.

all i am trying to do is color the cells as a line bar to show what
time the employee is working. the number of employees needed per hour
comes from a formula that matches hourly projections to crew needed per
projection... thanks to everyone's help here that parts done so i just
input the projection for the week and it gives me the correct number of
employees for each hour now i just need a bar or color or something that
ties it in to the employees??

IS this confusing enough?
I wish i could just send the sheet to view because its not as
complicated as i am making it..

any suggestions, Thanks in advance!!!
 
Top