If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL
I NEED A FORMULA TO DO THIS:
IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7 OR H7 MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN D18 WILL TURN RED |
#2
|
|||
|
|||
CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL
BTW... G7="DAYS" AND H7="HALF" "MomHudd" wrote: I NEED A FORMULA TO DO THIS: IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7 OR H7 MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN D18 WILL TURN RED |
#3
|
|||
|
|||
CONDITIONAL FORMATITING BASED ON TEXT IN ANOTHER CELL
Use this as the CF formula for D18:
=AND(D18G7,D18H7) Format to taste, ok out p/s: Do not use all caps in your posting (its impolite and difficult to read). Do not multi-post, ie post the same question in multiple excel newsgroups (it wastes responders' time) -- Max Singapore --- |
Thread Tools | |
Display Modes | |
|
|