Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hello,
I understand how conditional formatting works but can't seem to figure out a formula - will you please help? What formula would I use in order to change the format of cells A5:A17 if the number is equal to or greater than A1? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Select the range A5:A17 (with A5 active)
then apply CF using Formula Is: =AND($A$1<"",A5=$A$1) Format to taste, ok out Works? Click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Jim" wrote: I understand how conditional formatting works but can't seem to figure out a formula - will you please help? What formula would I use in order to change the format of cells A5:A17 if the number is equal to or greater than A1? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
select a5:a17 range, and on the formula is of the cond format use
=a5=$a$1 format as you need. hth -- pleae click yes if it was helpfull regards from Brazil Marcelo "Jim" escreveu: Hello, I understand how conditional formatting works but can't seem to figure out a formula - will you please help? What formula would I use in order to change the format of cells A5:A17 if the number is equal to or greater than A1? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
CF/ Cell Value Is/ Greater than or equal to/ =A$1
or CF/ Formula Is/ =A5=A$1 -- David Biddulph "Jim" wrote in message ... Hello, I understand how conditional formatting works but can't seem to figure out a formula - will you please help? What formula would I use in order to change the format of cells A5:A17 if the number is equal to or greater than A1? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | 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 |