#1
|
|||
|
|||
Conditional formatting
Hi All,
Please help me about conditional formatting, suppose I will type an exact word or value "TEST" in cell A2. Is there a way after typing the word "TEST" in cell A2 the cells from A1 to A5 will change to my desired fill color? I know there's a way out here please help. I am using MS OFFICE 2007 Thank you in advance. |
#2
|
||||
|
||||
Select the range A1to A5 in the CF wizard and enter =$a2="test" as condition. Select your format - Done
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks for your reply, but it's not working.
|
#4
|
||||
|
||||
Then post a sample sheet showing what you want to achieve. ( "it's not working" does not really help to help you)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
conditional formatting, excel 2007, ms office 2007 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting | bbutl027 | Excel | 15 | 12-05-2016 08:56 PM |
Conditional formatting | marif300 | Project | 9 | 09-23-2014 07:23 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |