Results 1 to 5 of 5

Cell formatting by formula or macro?

Threaded View

Artisan Cell formatting by formula or... 01-06-2009, 06:40 AM
deadlyduck You can achieve this using... 01-06-2009, 06:57 AM
Artisan Thank you. 01-06-2009, 07:09 AM
oldchippy Hi, Something like this 01-06-2009, 07:01 AM
oldchippy If you are satisfied with the... 01-06-2009, 07:19 AM
  1. #1
    Registered User
    Join Date
    07-04-2008
    Location
    Leicester
    Posts
    12

    Cell formatting by formula or macro?

    Hi,

    I was hoping someone can help me please.

    A1=text A2 will either be "yes" or "No"

    What I want to do is format A1 by either a fill colour or text colour. Any type of format I guess. If A2 is "Yes" then A1 is green and If A2 is "No" then A1 is red.

    Many thanks in advance and probably sorry for being a bit thick.

    Mark
    Last edited by Artisan; 01-06-2009 at 07:12 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