Results 1 to 4 of 4

Conditional Formatting based on Text

Threaded View

avidcat Conditional Formatting based... 12-31-2010, 05:47 AM
Marcol Re: Conditional Formatting... 12-31-2010, 06:36 AM
avidcat Re: Conditional Formatting... 12-31-2010, 06:44 AM
avidcat Re: Conditional Formatting... 12-31-2010, 07:11 AM
  1. #1
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Conditional Formatting based on Text

    I used this formula in a conditional formatting to highlight/shade a row based on whether column G was greater than or less than 20:

    =ABS(N($G25))>=20

    I want to do the same thing but instead of a number I want to say if column G contains a certain text instead.

    For example if G contains the text "LOA" than the formula would be true.

    Thanks for any help.
    Last edited by avidcat; 12-31-2010 at 09:22 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1