This formula will automatically spill to as many cells as needed. Because there is now only one category per cell, you can apply conditional formatting rules - one rule for each category. Thanks for looking into this - I’m stuck. No idea how to add category colour coding! https:...
Colour solid(1) Combine(4) Combine Cut(1) Combine idw(2) Combine Join(2) combine two objects(1) combining parts(1) command(1) Command Input(1) command line(1) Commands(1) Community Insights(1) Compatibility(2) Complete Rebuild(1) Complex Bend(1) complex design(...
Forum:Excel Questions A Automatically change fill colour of cells Dear All If I type "L" into cell F2 I have used conditional formatting to change the colour to red, I also want to change the fill colour of cells "G2 to M2" to red. I have tried using copy and paste using paste sp...
Calculate price based on drop down menu selection Calculate SUM from another Excel Workbook files calculated columns : comparing a column with a text value. Calculated item Crash Calculated item in Pivot table error when field is grouped calculating % of completion with cell content containing a da...
Cell text color based on value greater or smaller than zero Cell value changed event(?) in DataGrid change messagebox style in wpf Change a datagrid's header text in WPF on C# runtime code change all objects color that use a same DynamicResource in wpf Change application exe icon at runtim...
colour change(1) colour management(1) colour scheme(1) colours dull(1) Column(7) Columns(7) COMCheck(1) Comments(1) Community Conversations(1) Companies(1) Company(1) Comparison(1) Compatibility(1) complaints(1) Complex Roof(5) complex shape(1) complex slopes(1)...
Data added to cell B1 via excel on iPhone. Date stamp eg 1/2/24 added to cell A1. Excel sheet now saved back to cloud (one drive). 2 days later open the same file on a different ios device…. It opens the file, sees that data has been inserted into B1 but sees the same form...
Re: Can Excel autoformatting choose the fill color automatically when I enter data in a ce How many entries are there? If you choose dark colours you'll need to start changing the font colour too. Depending on the purpose, I was wondering...
Re: Can Excel autoformatting choose the fill color automatically when I enter data in a ce How many entries are there? If you choose dark colours you'll need to start changing the font colour too. Depending on the purpose, I was wonderin...
Hi,If I want cell b5 to always have the identical value to a4 I can put =a4 in cell b5. However I change a4, b5 always has the identical value. Is there a...