| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
I NEED A FORMULA TO DO THIS:
IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7("DAYS") OR H7("HALF") MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN D18 WILL TURN RED |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
CF/ Formula is
=AND(ISTEXT(D18),D18<G7,D18<H7) Select your red format. -- David Biddulph MomHudd wrote: I NEED A FORMULA TO DO THIS: IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7("DAYS") OR H7("HALF") MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN D18 WILL TURN RED |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
Use ForumaIs:
=(AND(D18<D7,D18<H7)) and pick the proper font color. -- Gary''s Student - gsnu201001 "MomHudd" wrote: I NEED A FORMULA TO DO THIS: IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7("DAYS") OR H7("HALF") MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN D18 WILL TURN RED |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
THANKS! THAT WORKED PERFECTLY!
"Gary''s Student" wrote: Use ForumaIs: =(AND(D18<D7,D18<H7)) and pick the proper font color. -- Gary''s Student - gsnu201001 "MomHudd" wrote: I NEED A FORMULA TO DO THIS: IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7("DAYS") OR H7("HALF") MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN D18 WILL TURN RED |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CONDITIONAL FORMATTING FOR ONE CELL TO MATCH ANOTHER'S TEXT
You should take the trouble to close-off your identical query in .newusers as
well. The response there carries more useful notes for you beyond the immediate answer. -- Max Singapore --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting to match cell values | Excel Worksheet Functions | |||
| Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
| Link the format of one cell to another's | Excel Worksheet Functions | |||
Linear Mode
