| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Text Color When?
I have the following,
Col A Col B Col C Col D 123 James King LSF 321 Sean Smith Adecco 555 Ryan Mathis TSA I want the color of text in colums A, B, and C, to change to RED when anything besides LSF is entered in column D. I tried doing this through conditional formatting but keep getting the formula wrong, or should I even be using that method? Thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Text Color When?
Conditional Formatting is fine, highlight columns A,B,C, and in Conditional
Formatting select Formula Is from the drop down & enter =$D1<"LSF" (Assuming that A1 is your active cell.) and choose your formatting - red in this case. "Sean" wrote: I have the following, Col A Col B Col C Col D 123 James King LSF 321 Sean Smith Adecco 555 Ryan Mathis TSA I want the color of text in colums A, B, and C, to change to RED when anything besides LSF is entered in column D. I tried doing this through conditional formatting but keep getting the formula wrong, or should I even be using that method? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change color if text is = or not, to text in other column | New Users to Excel | |||
| Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
| Change text color | Excel Discussion (Misc queries) | |||
| Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
| Text Color Change | Excel Worksheet Functions | |||
![Sean[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
