Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maz Maz is offline
external usenet poster
 
Posts: 9
Default Fill color with if function

Hi.
I want to fill a cell with some color based on the value in other cell.
if a24 then a1 is blue.
Can anyone help me?
thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Fill color with if function

Hi,

Use conditional formatting.
Select A1 then
Format|Conditional Formatting
Formula is
Enter the formula =A24
Pick you colour
OK

Mike

"maz" wrote:

Hi.
I want to fill a cell with some color based on the value in other cell.
if a24 then a1 is blue.
Can anyone help me?
thanks

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Fill color with if function

You use conditional formatting to do this. Select A1, then click on
Format | Conditional Formatting and in the dialogue box select Formula
Is rather than Cell Value Is. Enter this formula:

=A24

Then click the Format button, then the Patterns tab (for background
colours) and choose your colour. OK your way out.

Hope this helps.

Pete

On Jul 30, 12:07*pm, maz wrote:
Hi.
I want to fill a cell with some color based on the value in other cell.
if a24 then a1 is *blue.
Can anyone help me?
thanks


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L N L N is offline
external usenet poster
 
Posts: 1
Default Fill Color with if function

I have a similar situation only I have 4 columns that I need all to be greater then 3 and then fill color to be used in my rank column. Is this possible?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you create IF function with YES/NO, and Color fill Brandon Excel Worksheet Functions 3 April 7th 23 12:25 PM
Can you do an IF function whether a cell has a fill color of Rose Kays Excel Question Excel Worksheet Functions 3 December 27th 05 09:49 PM
color fill cells based on IF function or formula Victor Jones Excel Worksheet Functions 1 November 23rd 05 04:17 PM
Fill Color with Keyboard Function Matt Cromer Excel Discussion (Misc queries) 5 November 4th 05 06:29 PM
Using boolean function for color fill Kanchi Excel Worksheet Functions 2 September 7th 05 01:19 AM


All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"