Formatting 1 cell depending on a value of another.

D

Darren

Heres what I have:
I have 1 sheet called TeamData and another sheet called MonthlyGain
I want to format cells on MonthlyGain dependent on the values of cells on
TeamData.
Cells on TeamData are either numbers or blank cells.

Heres the 1st cell and what I want it to do.

I want MonthlyGain!A7 to, if TeamData!C2="", turn the text to red.

I have tried the conditional formatting and setting my own formulae but it
doesn't work.

Any ideas would be appreciated and thankyou in advance.
 
D

Darren

Got it figured.
I can't access cells from another sheet. I had to copy the needed cells from
TeamData onto MonthlyGain then reference them from there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter based on named range cell - debug help required 3
Set destination sheet based on variable and paste data assistance 13
Excel does not accept text format! 0
Conditional format if difference in cell values greater than 0.50% 1
Word macro that can call cells out of Excel for a find and replace 0
VBA Coding Help for Beginner 0
Pasting a cell into bookmarked table from excel vba 1
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top