MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using colors in cells


Posted by Mike on October 16, 2000 10:36 AM

Hello,

Is there a way to have a cell and if the value is X then the color of the cell will change color of text and the cell itself. If anyone can help, please email me directly at mike@pmdiamond.com.

Thanks for your time.


Posted by Loren on October 16, 2000 12:45 PM


Use Format-Conditional formatting

Posted by Loren on October 17, 2000 1:29 AM

In addition to the answer you recieved above,
Step 1 Click FORMAT
Step 2 Click CONDITIONAL FORMATTING
Step 3 In the box that appears select CELL VALUE IS in the next reference area select EQUAL TO. in the third reference area Type the reference you wish in quotation marks ie "X" then click FORMAT this box that appears there allows you to select font styles and COLOUR etc as well you can add two more Conditions by clicking add and going through step 3 again.

I have just figured this out myself not one hour ago, how is that for timing

Best of luck
mikcassidy@mikesmail.com