Excel question...
without using conditional formatting, how can i get a cell to change colour in a standard IF statement, e.g.
IF(A1="Y","",WordingToChangeColour)
I'm sure there is a way of writing this into a formula - but i just cannot remember what it is. Each colour shade is designated a number, but it is what goes before (or after) it that is bugging me
Anyone??
Posted By: Yellalee on November 4th 2005 at 15:18:29
Message Thread
- Excel question... (General Chat) - Yellalee, Nov 4, 15:18:29
- This should help (General Chat) - dorset_canary, Nov 4, 15:45:57
- Many thanks - much appreciated! (n/m) (General Chat) - Yellalee, Nov 4, 15:51:27
- Try (General Chat) - T 07, Nov 4, 15:36:05
- Very helpful. (General Chat) - Yellalee, Nov 4, 15:43:27
- Sorry to say it, but that was a blub and a half. (General Chat) - Squiggles, Nov 4, 15:45:34
- I'm sorry... (General Chat) - Yellalee, Nov 4, 15:47:55
- lol, no need to apologise! (General Chat) - Squiggles, Nov 4, 15:51:50
- Ah, just seen above. (General Chat) - Squiggles, Nov 4, 15:52:15
- lol, no need to apologise! (General Chat) - Squiggles, Nov 4, 15:51:50
- I'm sorry... (General Chat) - Yellalee, Nov 4, 15:47:55
- Sorry to say it, but that was a blub and a half. (General Chat) - Squiggles, Nov 4, 15:45:34
- Very helpful. (General Chat) - Yellalee, Nov 4, 15:43:27
- This should help (General Chat) - dorset_canary, Nov 4, 15:45:57
Reply to Message
In order to add a post to the WotB Message Board you must be a registered WotB user.
If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.