Silvestru Posted March 21, 2018 Share Posted March 21, 2018 Hello forum, I would really appreciate your help with what I'm sure is a simple IFERROR formula. I want the first column to adopt the colour and text of the column with the higher number. As in the example below the cell's with higher number (2) adopt the text and colour of the heading. I would really appreciate your help! Link to comment Share on other sites More sharing options...
Area54 Posted March 21, 2018 Share Posted March 21, 2018 It might work as a Conditional Formatting function. I'm checking it out now. Will the numbers in the two columns always be different? Will you require more than two columns? Tried that as a two part approach. In cell formula to set the correct text. That, obviously, works. Can't get the colour match though. I'll try some more. This matches a problem I was seeking a solution to a while back. I'm convinced that - sooner or later - almost anything is possible in Excel. Ah! Got it. This solves the problem as I understand it. Step 1: In colum 1, the text column, add this forumula, assuming this is cell A1: =IF(B1>C1,"Green","Red") Step 2: Copy down the column Step 3: Select all active cells in column A. Step 4: Go to Conditional Formating, Choose "New Rule"; "Format Only Cells that Contain"; Set this to "Green", then select Format, Patterns and choose a green shade. Step 5: Repeat Step 4 for Red. If you have more columns the coding becomes more tiresome, but the logic will work. Hope that helps. 1 Link to comment Share on other sites More sharing options...
Silvestru Posted March 21, 2018 Author Share Posted March 21, 2018 Thank you very much Area54! Link to comment Share on other sites More sharing options...
Sensei Posted March 24, 2018 Share Posted March 24, 2018 I am often using conditional formulas for filtering in OpenOffice Calc. e.g. =IF(A1>10;A1;"") What I don't want to see, is not displayed at all. Link to comment Share on other sites More sharing options...
Area54 Posted March 24, 2018 Share Posted March 24, 2018 11 hours ago, Sensei said: I am often using conditional formulas for filtering in OpenOffice Calc. e.g. =IF(A1>10;A1;"") What I don't want to see, is not displayed at all. We solved the problem 'offline' via pm. Anyone interested in the solution can pm me for the simple spreadsheet. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now