Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Colour

Excel Colour

ResolvedVersion 365

Thu 19 Nov 2020, 16:30 Delegate Alex said...

Alex has attended:
Excel Advanced course

Excel Colour

Hi,

I am trying to create a summary table with two coloumns that will be populated with a brand name / date.

To get the brand names / dates this will be based off if another cell in the table is red. Is there a way to search if a cell is red then return the brand name / date from another cell based on if it is? Whilst also not returning any results for the cells that didn't meet the criteria so I don't have blank cells in the summary.

Thanks for any help :)

Thu 19 Nov 2020, 21:46 Trainer Dennis said...

RE: Excel Colour

Hi Alex

Currently, there is no way in Excel of making decisions based on a cells formatting.

You could use something such as an IF function, along with a vlookup, to make decisions based on other criteria.

Regards

Dennis

Thu 26 Nov 2020: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips

Excel Colour

Excel Colour

RE: Excel Colour

Excel articles

Excel tip:

Create Equations in Excel 2010