hello tony. thanks for the speedy response.
the drop down is in cell D40 with to options .. over and under .. however that is not changed until the bank deposit
is put into cell h40. so therefore, if h40 is a negative number and the manager select the under from the drop down
it will be Red. if a positive number the over stays white.
mac excel 2011
thanks a bunch.
I'm not familiar with Mac Excel 2011.
If I understand what you want to do here's how I would do it in Windows Excel 2010.
Select cell D40
Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format
Enter this formula in the box below:
=AND(D40="Under",H40<0)
Click the Format button
Select the Font tab
From the Color drop down select a shade of red
OK out
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
hi thanks for the mgs.
no luck.
when i put in the unconditional format in d40 that you gave me above. the under does not turn red.
cell h40 does show a negative number .. as the bank deposit was not enough to cover the cash for the day.
so even when i play around with the cell values to increase the negative in h40 .. i would hope to toggle the drop
drop and the under would appear red.
can i send you a snap shot of the cells involved.
regards, barbara
Let me see if I can find someone that also uses a Mac...
tony .. i do not think it is a mac issues. i see all the selections you guided me to .. it appears under Classic in the new rule section.
it just not seem to like the formatting .. ?? i will leave it with you if you think a mac associate could help.
thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks