Colour Cell based on Content
here's one I'm sure has been asked many times before...
Column A, contains an option of HIGH, Medium, Low. Based on what is entered, colour the cell automatically, Red, Yellow, Green. Anyone got the formula? Or do I need to put some code in? I don't know how to put code in, so if this is answer, please give brief guide too! Thanks... |
Colour Cell based on Content
Use conditional formatting: Format Conditional Formatting. Set your three
conditions--you need to Add your second and third conditions. "Steve" wrote: here's one I'm sure has been asked many times before... Column A, contains an option of HIGH, Medium, Low. Based on what is entered, colour the cell automatically, Red, Yellow, Green. Anyone got the formula? Or do I need to put some code in? I don't know how to put code in, so if this is answer, please give brief guide too! Thanks... |
Colour Cell based on Content
Select all of Column A Click Format Conditional Formatting Create three conditions: Condition 1 = If Cell Value is eqaul to High -- then choose your formatting options. Click "Add" and repeat for other desired conditions. Profit. -- SlipperyPete ------------------------------------------------------------------------ SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220 View this thread: http://www.excelforum.com/showthread...hreadid=521089 |
Colour Cell based on Content
<Format<Conditional Formatting
Choose "Formula is" Enter 3 conditions, each having one of the following formulas (assuming cell A1): =A1="High" =A1="Medium" =A1="Low" Choosing the format for each, respectively. -- Regards, Dave "Steve" wrote: here's one I'm sure has been asked many times before... Column A, contains an option of HIGH, Medium, Low. Based on what is entered, colour the cell automatically, Red, Yellow, Green. Anyone got the formula? Or do I need to put some code in? I don't know how to put code in, so if this is answer, please give brief guide too! Thanks... |
All times are GMT +1. The time now is 01:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com