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



"darkbearpooh1" wrote:


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: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=503516