software

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?--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=503516Let's say you want to Conditionally Format cell A1 to become red if cell B1 =
5.

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

HTH,
Elkar
quot;darkbearpooh1quot; wrote:

gt;
gt; I need to conditional format a cell based on the condition of a
gt; different cell is this possible? could someone post a formula to help
gt; me?
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=503516
gt;
gt;


Thanks!!!!!!!!!!! thats great!--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=503516
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?--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=503516You could use the AND and OR functions.

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

=OR(AND(B1gt;=5,B1lt;=10),B1=15)quot;darkbearpooh1quot; wrote:

gt;
gt; Ok, Now how do i make it accept a range like you said conditional format
gt; if A1=5 but I need it to accept several different numbers and still
gt; change color?
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=503516
gt;
gt;


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!!!--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=503516