• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting question involving referential cells

C

cvn65sailor

New Member
How does one do conditional formatting involving:


- The creation of a referential cell (i.e. $) and get it to accept conditional formatting in Excel 2010?


I have a colleague who is trying to accomplish this without having cut and paste formatting into her 1,000 cell table.
 
Cvn65sailor


Firstly, Welcome to the Chandoo.org Forums


With all CF you select the area to which CF will be applied

Then apply CF using the top left cell as the cell on which the CF is based

You need to use $ as appropriate as if it were a regular formula being copied across and down


If you want to share a sample file or the formula we may be able to give you more targeted advice
 
Hi my name is Henk and I'm in Melbourne. I was wondering now that I have Office 2010 whether I can do a conditional format to compare a range of cells that have all different values in them to a row of 15 cells. Range being C14:G150 and Row being M4:X4. If a cell in the range is the same number as in the row, then change the value in the range to the Cell REFERENCE of the Row. I would only need to apply this rule once as once it has been done the range would be complete with cell references. Once I have the cell references in the range i can change the numbers in the row and the cell references will automatically change them in the range.


I used to have a code in VB in excell 2003 but was hoping to do it simply in conditional format option 2010 as there you can add more then 3 conditions.


Hope someone can help with a formula I can simply add into conditional farmatting tab.
 
Hi, henksss!


Tried this?

=HLOOKUP(C14,$M$4:$X$4,1,FALSE)

applied to range C14:G150.


Regards!


PS: Next time please start a new topic so as to not hijack other user's ones.
 
Sorry SirJB7 Thanks for the advise I'm fairly new here not sure how to start new topic will look into it.


However having said that I tried your formula but doesn't work, nothing happens.


Regards Henk
 
Hi, henksss!

Would you mind starting a new topic and uploading a sample file (including manual examples of desired output)? Maybe I didn't fully understand your issue. Thank you.

Give a look at the second green sticky post at this forums main page for uploading guidelines.

Regards!
 
You must log in or register to reply here.
Back
Top