Unconditional formatting not colouring the cells and not copying across

		Microsoft Office Forums > Microsoft Excel > Excel
Unconditional formatting not colouring the cells and not copying across

FAQ

Thread Tools

Display Modes

11-24-2020, 05:19 PM

Steve36

Windows 10 Unconditional formatting not colouring the cells and not copying across

Office 2016

Novice

Join Date: Nov 2020

Posts: 6

Unconditional formatting Copying it across help

Hi Please can anyone help me on this.

See attached spreadsheet

On D339

I select the list and select the subject however, its proving very time consuming to copy the conditional formula across.
I want to select subjects and then it should change color of the below cells.

=COUNTIF(D$339,"Drama")>0

How can I change the formulea so it is easy to copy across to the other cells and the ones below?

Please help

Attached Files

September return Staff V4.xlsx (88.0 KB, 12 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 2016 mac text not colouring propperly	GAMIE64	Word	1	04-29-2016 06:18 AM
Copying Same Value Between Two Cells	rsrasc	Excel Programming	3	02-29-2016 10:53 PM
Copying text into multiple cells at once	BIMwit	Word Tables	1	05-14-2015 09:50 PM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Copying cells	isminoh	Excel	5	04-18-2012 11:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 PM.