| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting if and And
Hi,
=OR(F3="Schedule booked",AND("D3<C3")) I am trying to write if cell F3 reads "Schedule booked" AND cell D3 is less than cell C3 then statement is true so field should change colour. Help, my formular is not working. -- K |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting if and And
Check your other post..You dont need to duplicate..
OR is not needed. Use the AND(condition1,condition2) Done use double quotes for references.... =AND(F3="Schedule booked", D3<C3) -- If this post helps click Yes --------------- Jacob Skaria "ROPL" wrote: Hi, =OR(F3="Schedule booked",AND("D3<C3")) I am trying to write if cell F3 reads "Schedule booked" AND cell D3 is less than cell C3 then statement is true so field should change colour. Help, my formular is not working. -- K |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting if and And
I had to duplicate as the system informed me it has not been sent.
Your answer is perfect. Thank you so much. -- K "Jacob Skaria" wrote: Check your other post..You dont need to duplicate.. OR is not needed. Use the AND(condition1,condition2) Done use double quotes for references.... =AND(F3="Schedule booked", D3<C3) -- If this post helps click Yes --------------- Jacob Skaria "ROPL" wrote: Hi, =OR(F3="Schedule booked",AND("D3<C3")) I am trying to write if cell F3 reads "Schedule booked" AND cell D3 is less than cell C3 then statement is true so field should change colour. Help, my formular is not working. -- K |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
