fill colour

tonyg · Apr 4th, 2002, 12:50 PM

I want to fill a cell colour ie G6 when a date is entered in E6. How do i do it please?

lenze · Apr 4th, 2002, 12:55 PM

Use conditional Formatting in G6
Choose the 'Formula Is' Option
Enter =ISNUMBER(E6)

bobmc · Apr 4th, 2002, 12:58 PM

Use conditional formatting...

cell value - not equal to - $E$6

Change the cell shading to the desired color within the Conditional Formatting dialogue box.

Mark W. · Apr 4th, 2002, 01:20 PM

Some more restrictive format conditionals include...

=AND(E6>"12/31/2001"+0,LEFT(CELL("format",E6))="D")

...which differentiates between "any old number" and a datevalue beyond 2001. Furthermore, it
requires E6 to be formatted to "look" like a date.

[ This Message was edited by: Mark W. on 2002-04-04 12:24 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 12:50 PM	#1
tonyg New Member Join Date: Apr 2002 Location: Tony Gennoe Posts: 1	I want to fill a cell colour ie G6 when a date is entered in E6. How do i do it please?

Apr 4th, 2002, 12:55 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Use conditional Formatting in G6 Choose the 'Formula Is' Option Enter =ISNUMBER(E6)

Apr 4th, 2002, 12:58 PM	#3
bobmc Board Regular Join Date: Mar 2002 Posts: 142	Use conditional formatting... cell value - not equal to - $E$6 Change the cell shading to the desired color within the Conditional Formatting dialogue box.

Apr 4th, 2002, 01:20 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Some more restrictive format conditionals include... =AND(E6>"12/31/2001"+0,LEFT(CELL("format",E6))="D") ...which differentiates between "any old number" and a datevalue beyond 2001. Furthermore, it requires E6 to be formatted to "look" like a date. [ This Message was edited by: Mark W. on 2002-04-04 12:24 ]