Discover advanced Excel conditional formatting techniques. Automate your spreadsheets by detecting duplicates, finding ...

Excel's Conditional Formatting will show you, by doing everything from creating a border around the highlights to color-coding the entire table. It'll even build a graph into each cell to visualize ...

While working with the visual I found a little bug: The case is a table where I used a specific column for the conditional formatting. You can see it in the screenshot below. The culomn in the green ...

I would like to set multipe formating in one conditional formating. range.AddConditionalFormat().WhenIsTrue(string.Format("=$N${0} > $R${0}", i + 13)).Font.FontColor ...

I have a spreadsheet, cells A1 to D100 are active. If D1 contains a figure I want the whole A1:D1 to change to green. I can do this, no trouble, conditional formating ...

When Google Earth Pro was first made available for free we had a look at the advanced printing options in Google Earth Pro that are not found in the standard version. We recently had an enquiry from a ...

I have a spreadsheet whitch contains text in the cells. I need some cells to change colour depending on the content (text) in the earlier cell. F.exs A1 contains the text LVDH, then B1 should turn red ...