PC Review


Reply
Thread Tools Rate Thread

Conditional Formatting (two sheets three cells)

 
 
=?Utf-8?B?S0Fub2U=?=
Guest
Posts: n/a
 
      30th Oct 2006
I need to do a Conditional Format that will check the date that I have set on
Sheet 1 Cell A3 compared to Sheet 2 Cell E1. If the Date in is before SH1,CA3
then Cell A1 on sheet 2 will have a red background.

Can I do this?

Thanks

Keith
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      30th Oct 2006
You need to name the cell on Sheet1 and compare the name to cell E1.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"KAnoe" <(E-Mail Removed)> wrote in message
news220D99E-6044-4A2A-B71F-(E-Mail Removed)...
> I need to do a Conditional Format that will check the date that I have set

on
> Sheet 1 Cell A3 compared to Sheet 2 Cell E1. If the Date in is before

SH1,CA3
> then Cell A1 on sheet 2 will have a red background.
>
> Can I do this?
>
> Thanks
>
> Keith



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting In and Across Sheets =?Utf-8?B?amts?= Microsoft Excel Misc 8 27th May 2010 09:53 PM
Conditional Formatting across Sheets Corey Microsoft Excel Worksheet Functions 5 5th Jan 2007 01:12 PM
Why Not Conditional Formatting For Multiple Sheets? Mhz Microsoft Excel New Users 2 13th Jul 2006 01:27 PM
conditional formatting across sheets athleticospizz Microsoft Excel Worksheet Functions 6 24th Apr 2004 08:38 PM
Conditional Formatting on Different Sheets George Bundy Microsoft Excel Worksheet Functions 3 26th Mar 2004 02:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:54 PM.