| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I am trying to create a conditional format which will highlight the specific
cell red when it brings up an error. If column O is filled in without column M having the text "offer" in it, I want it to turn red. I want this if an option has been chosen in column O, not if column O is blank. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Click on Format, Conditional Format, select Formula is and enter the following:
=AND($O2<"",$M2<"Offer"), select Format, Patterns and Red, OK out. Obviously change row numbers to suit -- Hth Kassie Kasselman "Alex" wrote: I am trying to create a conditional format which will highlight the specific cell red when it brings up an error. If column O is filled in without column M having the text "offer" in it, I want it to turn red. I want this if an option has been chosen in column O, not if column O is blank. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Thanks Kassie, I should of mentioned I had three seperare conditions in
column M which begun with "offer", but I was able to use your help with the =and, I came up with this. =AND($O10<"",(LEFT(M10,5)<"Offer")) "kassie" wrote: Click on Format, Conditional Format, select Formula is and enter the following: =AND($O2<"",$M2<"Offer"), select Format, Patterns and Red, OK out. Obviously change row numbers to suit -- Hth Kassie Kasselman "Alex" wrote: I am trying to create a conditional format which will highlight the specific cell red when it brings up an error. If column O is filled in without column M having the text "offer" in it, I want it to turn red. I want this if an option has been chosen in column O, not if column O is blank. Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Glad I could help Alex. Thanks for the feedback
-- Hth Kassie Kasselman "Alex" wrote: Thanks Kassie, I should of mentioned I had three seperare conditions in column M which begun with "offer", but I was able to use your help with the =and, I came up with this. =AND($O10<"",(LEFT(M10,5)<"Offer")) "kassie" wrote: Click on Format, Conditional Format, select Formula is and enter the following: =AND($O2<"",$M2<"Offer"), select Format, Patterns and Red, OK out. Obviously change row numbers to suit -- Hth Kassie Kasselman "Alex" wrote: I am trying to create a conditional format which will highlight the specific cell red when it brings up an error. If column O is filled in without column M having the text "offer" in it, I want it to turn red. I want this if an option has been chosen in column O, not if column O is blank. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Hybrid Mode
