If C4 on sheet 2 is less than 5, then fill cell A2 on sheet 1 with red.
how can that be done in Excel 2007 without VBA ?
If C4 on sheet 2 is less than 5, then fill cell A2 on sheet 1 with red.
how can that be done in Excel 2007 without VBA ?
Last edited by Eddiegnz1; 11-26-2013 at 12:31 PM.
should be able to
in cell A2 - conditional format
formula and put
=sheet2!c4<5
see attached
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
You cannot directly reference a cell on another worksheet by conditional formatting (in excel 2003) but you can using a named range.
Create a named range "formatrng1" and assign it to sheet2 cell C4
then apply the conditional format to sheet1 A2 of:
=formatrng1<5
and change background for conditional format to red.
Edit: sorry - saw the version on your profile, didn't notice the 2007 bit in the post.
Your comment stands for 2007 as well, 2007 also cannot directly reference other sheets
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
oh right, saw etaf had uploaded a workbook with that method so assumed it worked in later versions..
I think they fixed that in 2010
Your profile suggests 2003 as well?
FDibbins - if that is aimed at me, then yes I use 2003.
my solution was for 2010 - should have said
@FDibbins
It's a reluctant attempt to try and pick up 2007 before I'm forced to change at work..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks