[Pls Help!]Grant chart project with conditional formatting

maiwarits

New Member
Joined
Jul 17, 2022
Messages
34
Office Version
  1. 365
Platform
  1. Windows
Hi guys!

I am making my grant chart to tracking multiple projects. This picture show the total view.
1675483476026.png


1) There is a way to highlight the entire row if column A contain integer even or odd number only [1,2,3,..]. I don't want them to highlight the row there is not a integer. [1.1,1.2,.. ]
This is my condition:
Excel Formula:
 =ISODD($A8)
1675483864142.png

PS. I will add one more condition for even number to highlight with different colour.

2) I have 2 conditions to show this
Excel Formula:
=AND($D8<=I$6,ROUNDDOWN(($E8-$D8+1)*$G8,0)+$D8-1>=I$6)
Excel Formula:
=AND(NOT(ISBLANK($D8)),$D8<=I$6,$E8>=I$6)
1675484051972.png
1675484083480.png

Is it possible to assign condition if column A contain even then show one color or column A contain odd number then show the different color?

3) Is it possible to copy word in the column B then show on the start date in the current row? Pls see the detail in below pictures.
( cell I6 contain date that copy from D3 then plus1 for next column.)
1675484636584.png


Sorry if my explanation does not clear.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
You could use

And($A8<>"",INT($A8)=$A8)
as a conditional formatting rule
then also make sure that that is first in the list - with the arrows and use STOP IF TRUE -
that should colour the row

you then go on to say ODD - EVEN
is that also when an integer

And($A8<>"",INT($A8)=$A8,ISODD($A8))
And($A8<>"",INT($A8)=$A8,ISEVEN($A8))

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.

Therefore -

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

You can also test to see if it works ok, in the "Test Here" forum.

OR if you cannot get XL2BB to work, or have restrictions on your PC , then put the sample spreadsheet onto a share
I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed
 
Upvote 0

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top