About Us

Maz

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

Mike H

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

Pete_UK

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

L N

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?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 08:49 PM
color fill cells based on IF function or formula	Victor Jones	Excel Worksheet Functions	1	November 23rd 05 03:17 PM
Fill Color with Keyboard Function	Matt Cromer	Excel Discussion (Misc queries)	5	November 4th 05 05:29 PM
Using boolean function for color fill	Kanchi	Excel Worksheet Functions	2	September 7th 05 01:19 AM

Menu

About Us