Function and Formatting

[Mr. Hanes]

Hello,

I would like to format a range of cells to turn a select color when i enter a certain text into a seperate range of cells.

Ex;

I want range B2:G114 to turn "green" automatically if J2:J114 is a text " Call back"

So if cell J5 contains "Call Back" I would like the row of B5:G5 to turn green and so on down the line

Thank you for your Help it is much appreciated!

[FDibbins]

use conditional formatting.
1st, select the range you want to apply it to.
then, under CF, select "new rule" then "use formula"
enter something like =J5="Call Back"
select the color you want

let me know how you make out

[Mr. Hanes]

Unfortunately it didnt work. It only changed the color of cell A2

[FDibbins]

upload a sample workbook, and i will walk you through it
To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.