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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com