Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula results to be highlighted through IF function?
I have a column displaying number of days to go to an event.
I undertand that I can automatically highlight this number if less than a pre-set amount of days. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula results to be highlighted through IF function?
hi
read up on conditional formating. i think that is what you are after. regards FSt1 "russ68" wrote: I have a column displaying number of days to go to an event. I undertand that I can automatically highlight this number if less than a pre-set amount of days. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula results to be highlighted through IF function?
Highlight your relevant cells or column and click Format, Conditional
Formatting. Where it says 'Condition 1' leave the box below to say 'Cell Value Is'. Change the next box to say 'less than', and in the third box type in the number to be less than. Now click the 'Format' Button and go to the 'Patterns' tab. Choose a highlight colour and click 'OK'. Finally click 'OK'. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "russ68" wrote: I have a column displaying number of days to go to an event. I undertand that I can automatically highlight this number if less than a pre-set amount of days. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF function - results are the formula only | New Users to Excel | |||
how do i do a highlighted formula? | Excel Worksheet Functions | |||
use if function if field is highlighted in colour in excel | Excel Discussion (Misc queries) | |||
Can I use a function to detect whether a cell is highlighted? | Excel Worksheet Functions | |||
Function Formula is displayed not results | Excel Worksheet Functions |